title: How to convert year format "yy" as "yyyy" in Oracle
body: <p>I tried to insert values from a table G0DM to G0RDM. The problem am facing is that date in Column DOJS in table GODM certain dates are specified as "01-01-00" format.. the year value is entered as "00" which needs to be displayed as 2000. I  tried changing the database entries manually but even though I tried the error keeps coming. Other columns which is related to dates also has the same problem. So changing it manually is so difficult..</p>
  
  <p>My query:</p>
  
  <pre><code>INSERT INTO g0rdm
              (aud_number,
               short_code,
               entitlement_number,
               abbrevi,
               name,
               designation,
               person_charge,
               office_name,
               place,
               dob,
               dojs)
  SELECT aud_number,
         short_code,
         entitlement_number,
         abbrevi,
         name,
         designation,
         person_charge,
         office_name,
         place,
         To_date(dob, 'dd-mm-yyyy'),
         To_date(dojs, 'dd-mm-yyyy')
  FROM   g0dm; 
  </code></pre>
  
  <p>The error message is :</p>
  
  <pre><code>SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
  01841. 00000 -  "(full) year must be between -4713 and +9999, and not be 0"
  *Cause:    Illegal year entered
  *Action:   Input year in the specified range
  </code></pre>
  
  <p>Any solution?</p>