Re: sql*loader and Date

On 18 May 2006 19:26:51 -0700, "swaxolez" <willem_at_pcfish.ca> wrote:

>I'm trying to load a csv file into a table and keep having the
>following error pop up:
>
>Record 1: Rejected - Error on table HYDDATA, column Cr_DATE.
>ORA-01847: day of month must be between 1 and last day of month
>
>My Control File is:
>
>LOAD DATA
> INFILE A2.CSV
> TRUNCATE
> CONTINUEIF NEXT(1:1) = '#'
> INTO TABLE HYDDATA
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
> TRAILING NULLCOLS (
> Cr_Date DATE (10) "DD/MM/YY",
> Cr_Time,
> PSI,
> GEOMETRY COLUMN OBJECT
> (
> SDO_POINT COLUMN OBJECT
> (X FLOAT EXTERNAL,
> Y FLOAT EXTERNAL)
> ),
> Longitude,
> Latitude,
> Heading,
> Speed,
> Mode,
> Action,
> ID
>
>)
>
>and my input data is of the following format:
>
>30/04/2006,16:01:54,806,-121.6359816,34.4566166,157.1,0,0,0,1
>
>Any help would be greatly appreciated.
>
>Thanks

The (10) is redundant. Remove it and see what happens. Also DD/MM/YY is incorrect, it should be DD/MM/YYYY as your sample data demonstrates.

--
Sybrand Bakker, Senior Oracle DBA