title: Date formating with Character field
body: <p>I have a character field that represents the date as <code>'01-JAN-13'</code>.  When I reformat with <code>TO_DATE(SUBSTR(DSIS_CC_MASTER.created_ts, 1, 9),'YYYY-MM-DD')</code>, I get the result as <code>13-JAN-01</code>.</p>
  
  <p>How to get the data in format <code>YY-MM-DD</code>. Do I need to write in a CASE to change the month to numbers?</p>
  
  <pre><code>SELECT dsis_cc_master.created_ts
       , to_date(substr(dsis_cc_master.created_ts, 1, 9), 'YYYY-MM-DD') AS created_month
    FROM traffic_eng.dsis_cc_master
   WHERE dsis_cc_master.created_ts &gt;= to_date('2013-01-01', 'yyyy-mm-dd')
  </code></pre>
  
  <p>My result is </p>
  
  <pre><code>01-JAN-13    13-JAN-01
  </code></pre>
  
  <p>I am trying to get <code>01-01-13</code> or <code>13-01-01</code> in the second column.</p>