Home » RDBMS Server » Server Utilities » sqlldr :Date format problem
sqlldr :Date format problem [message #73870] Tue, 27 July 2004 19:54 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
Dear all,

I am using SQL*Loader to load the data from a plain text file from Informaix to table (temp) that contains a field filed1 of DATE format.

The text file is as follows,

2004-05-01 11:30,

2004-04-01 13:30,...

As i know the default date format is DD-MM-YYYY,so how can i deal with the above data so that i can load it into my table temp.

Thank for your kind help!!

Regards,

David

Report message to a moderator

Re: sqlldr :Date format problem [message #73874 is a reply to message #73870] Wed, 28 July 2004 02:47 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
Use this in your control file:

field1 "to_date (:field1, 'yyyy-mm-dd hh24:mi')"

Report message to a moderator

Previous Topic: very Urgent Help
Next Topic: Migration from 7.3 to 8i (URGENT)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 09:48:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.