SQL*Loader and Dates HELP!
From: JMNpst <jmnpst_at_aol.com>
Date: 25 Feb 2000 15:33:26 GMT
Message-ID: <20000225103326.16401.00001182_at_ng-dc1.aol.com>
[Quoted] 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 Fri Feb 25 2000 - 16:33:26 CET
Date: 25 Feb 2000 15:33:26 GMT
Message-ID: <20000225103326.16401.00001182_at_ng-dc1.aol.com>
[Quoted] 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 Fri Feb 25 2000 - 16:33:26 CET