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:
BEGIN new_updated_date := TO_DATE(:LAST_UPDATE_DATE, 'MM/DD/YYYY HH24:MI');
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.
I would guess that some of your dates are coming in without the century component, eg, 12/3/13 rather than 12/3/2013. In that case the YYYY format will transform it to 0013. You could try the RRRR fromat, which if the century component is missing, will make a guess for the century, either 19 or 20 depending on the current date and the input.