SQL*Loader Control File Custom Date Format

Question

3k views Asked by S_S At 17 October 2024 at 02:27

I need to import from a CSV file in which timestamps are given in the following format

2014-06-14T09:38:29

I tried the following in the control file for SQL*Loader but it doesn't work

TIME DATE "YYYY-MM-DDTHH:MI:SS"

and

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

There are 1 answers

**Tharunkumar Reddy** · Accepted Answer · 2015-06-23 05:47:22

Tharunkumar Reddy On 23 June 2015 at 05:47 BEST ANSWER

Try with below code

time date 'YYYY-MM-DD"T"HH24MISS'