Re: SQL*Loader and Dates HELP!

Base on my extensive experience (3 months) you need to specify the format in your control file.

Example, if the date you wish to load is formatted like 09121999 (MMDDYYYY) the line in your control file should look like this

Mydate DATE(8) "MMDDYYYY",

Not sure what 'C' stands for unless it is Century?

JMNpst wrote:

> In my flat file, I have dates that are specified as CYYMMDD. My control file
> codes these dates as a DATE type, which according to Oracle is DD-Mon-YYYY.
> Obviously, no data gets inserted into the file I am trying to load. How can I
> do this? Is there a way with the control file to convert the CYYMMDD to the
> Oracle standard during the SQLLDR run? Or do the dates have to be correct in
> the flat file first.
Received on Sat Feb 26 2000 - 03:35:42 CET