Re: sql loader time field only no date
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 05 May 2004 09:08:37 -0700
Message-ID: <1083773316.247622_at_yasure>
>
>
> 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).
> --
> TomekB
Date: Wed, 05 May 2004 09:08:37 -0700
Message-ID: <1083773316.247622_at_yasure>
Noel wrote:
[Quoted] >>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).
> --
> TomekB
And is there an explanation for the 'interesting' usage of mixed isngle and double quotes?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed May 05 2004 - 18:08:37 CEST