Timestamp field into oracle by using sqlloader

Question

I am trying to load this source row into oracle

Source row:

1000-01-01 00:00:00:000000

by using this CTL statement;

entrydate TIMESTAMP "YYYY-MM-DD hh:mi:ss:ff6"

but I am getting

ORA-26041: DATETIME/INTERVAL datatype conversion error

What am I doing wrong?

Arkadiusz Łukasiewicz · Accepted Answer · 2017-03-17 13:08:31Z

1

Timestamp format or data problem hh - Hour of day (1-12). hh24 - Hour of day (0-23).

TIMESTAMP "YYYY-MM-DD hh24:mi:ss:ff6" try this version.

answered Mar 17, 2017 at 13:08

6,3761 gold badge13 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1