Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.
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).
-- TomekBReceived on Wed May 05 2004 - 04:23:19 CDT