title: Oracle date to string conversion
body: <p>I have a string column COL1 when I am doing this</p>
  
  <pre><code>SELECT TO_CHAR(TO_DATE(COL1,'dd-mon-yy'), 'mm/dd/yyyy')
  FROM TABLE1
  </code></pre>
  
  <p>The data in COL1 is in dd-mon-yy, eg: 27-11-89 and 89 is 1989 but the select returns it as 11/27/2089.</p>
  
  <p>I have to do an inner TO_DATE because if I don't then I am getting an invalid number error (ORA-01722: invalid number) </p>
  
  <p>How can show 1989 instead of 2089? Please help</p>