Home » RDBMS Server » Server Utilities » SQLLDR date format problem
SQLLDR date format problem [message #205710] Mon, 27 November 2006 03:45 Go to next message
Messages: 20
Registered: December 2005
Junior Member

I am using oracle and running sqlldr for loading the flat file.
All things are fine But when I use date format as :

cdate DATE 'yyyy-mm-dd hh24:mi:ss.FF3',

it gives the error : ORA-01821: date format not recognized

My flat file have the date in this format.

Any clue...

Thanks & Regards

Arun Tayal
Re: SQLLDR date format problem [message #205745 is a reply to message #205710] Mon, 27 November 2006 05:26 Go to previous message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
The DATE datatype does not support fractional seconds. Try TIMESTAMP instead (assuming you are loading into a TIMESTAMP column, and not a DATE column).

Ross Leishman
Previous Topic: How to create .sh script in Linux for Export Operation
Next Topic: Error During Import
Goto Forum:

Current Time: Thu Jul 20 10:07:03 CDT 2017

Total time taken to generate the page: 0.10345 seconds