title: fnd_date.canonical_to_date function not working in oracle
body: <p>I have used <code>fnd_date.canonical_to_date</code> to convert a column to date data type.</p>
  
  <pre><code>the expected output is for example:29-JAN-2014
  but i am getting : 29-JAN-0014 
  </code></pre>
  
  <p>anyone knows why ?</p>
  
  <pre><code>l_actual_term_date varchar2(100);
  
   SELECT   to_char(ACTUAL,'DD-MON-RRRR')
             INTO l_actual_term_date           
             FROM per_table;
  
  --assign to another variable as per reqmt of date type
  
  prev_term_date :=l_actual_term_date;
  --WHEN printed this will give 29-JAN-12
  
  --then in another package have to aasign prev_term_date to a varchar type variable 
  
  P_prev_term_date :=fnd_date.canonical_to_date(prev_term_date);
  
  --when i print this P_prev_term_date i get - 29-JAN-0014 instead of 29-JAN-2014
  </code></pre>