title: 'DD-MON-RR' date format pattern not working as expected
body: <p>I am inserting a query with the format as </p>
  
  <pre><code>to_date('25-JUN-13','DD-MON-RR')
  </code></pre>
  
  <p>In <strong>oracle</strong> it is working fine and the output is as <code>25-JUN-13</code>.<br>
  In <strong>postgresql</strong>  the same is working as <code>0001-06-25 BC</code>.</p>
  
  <p>It is a <strong>migration project</strong> from the <strong>oracle database to postgresql</strong>. Any solution for the same to work as it is in the case of <strong>oracle</strong>. </p>
  
  <p>The same is not working correctly if I am using the <strong>DD-MM-YY</strong> format then the result is being very much different.</p>
  
  <p>RUNNING THIS QUERY IN POSTGRESQL --> </p>
  
  <pre><code>select to_char(to_date('25-JUN-53','DD-MON-YY'),'YYYY') as YEAR 
  
  ANSWER IS --&gt; 2053 
  </code></pre>
  
  <p>While retrieving the same result in oracle from the query as </p>
  
  <pre><code>select to_char(to_date('25-JUN-53','DD-MON-RR'),'YYYY') as YEAR from dual
  
  ASSWER IS --&gt; 1953
  </code></pre>
  
  <p>As I am migrating the project the same functionality should be there in the Postgresql so that the final result should be same.</p>