Re: sql loader time field only no date

> Thanks in advance.
> I have the following comma seperate fields:
> dlls001,0x000123456,545678,GMT-4:00-Eastern-DST,04/16/2004,10:18:22.4
> I am stuck with the following control file:
> LOAD DATE
> APPEND INTO TABLE ATTEMPT_REC
> FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
> (
> node char,
> gateway char,
> accId char,
> timeZone char,
> starDate date "MM/DD/YYYY",
> startTime timestamp "hh:mm:ss:d"
> )
> the error is Rejected - Error on table ATTEMPT_REC, column STARTTIME
> ORA-01843: not a valid month

Hi.
[Quoted] I give you a clue:

select to_date('10:18:22.4','hh:mm:ss:d') from dual; select to_date('10:18:22.4','hh:mi:ss"."dd') from dual;

And please read error message carefully... (mm is month not minutes).

--
TomekB