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
tayalarun
Messages: 20
Registered: December 2005
Junior Member
Hi,

I am using oracle 10.2.0.2.0 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
rleishman
Messages: 3724
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: Sat Dec 10 08:59:31 CST 2016

Total time taken to generate the page: 0.10693 seconds