1 Reply Latest reply: Dec 3, 2013 6:36 PM by Vite DBA RSS

    Date format changes while applying transformation rule during CSV loading


      Hi guys,


      I;m loading a CSV in APEX.

      Also applying a transformation rule which converts a column value from 12/3/2013 12:19 to 12/3/2013 as the reports should not reflect timestamp but only date.


      I've put the Rule as follows:


      new_updated_date DATE;

      BEGIN new_updated_date := TO_DATE(:LAST_UPDATE_DATE, 'MM/DD/YYYY HH24:MI');

      RETURN new_updated_date;



      While doing so, a lot of dates get converted to 12/3/0013 instead of 12/3/2013


      Let me know what could be the issue.