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

    Date format changes while applying transformation rule during CSV loading

    950123

      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:

      DECLARE

      new_updated_date DATE;

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

      RETURN new_updated_date;

      END;

       

      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.

      Thanks.