sqlldr :Date format problem [message #73870] |
Tue, 27 July 2004 19:54 |
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
|
|
|
|