Hi
The following is a sample of data I am attempting to load using sql ldr.
ENTITY->LOAD_DATE->SOME_FLAG
XX->2019-01-30 02:10:20.83043->Y
YY->2019-01-30 02:10:20.83043->X
"->" denotes tab delimited in the above sample.
The column on the table, TBL.LOAD_DATE, is DATE.
The control file I am using is :
options (skip=1
load data
infile 'some_file.txt'
into tbl
fields terminated by x'9'
trailing nullcols
(entity char(10),
date_with_ts filler,
load_date date "trunc(to_timestamp(:date_with_ts,'yyyy-mm-dd hh24:mi:ss:ff'))",
some_flag char(1)
)
I get the following sqlldr error :
ORA-01821: date format not recognized
Can anybody assist me with the correct date format?
Also, is there a way not to use a filler, instead format the load_date to date without referencing a filler ?