I need to import from a CSV file in which timestamps are given in the following format
I tried the following in the control file for SQL*Loader but it doesn't work
TIME DATE "YYYY-MM-DDTHH:MI:SS"
TIME DATE "YYYY-MM-DDTHH24:MI:SS"
How can I parse this custom date? The error I get is
ORA-01821: date format not recognized