Re: sql loader time field only no date

"Noel" <tomekb_at_softman.pl> wrote in message news:<c7abpu$c93$1_at_inews.gazeta.pl>...
> > 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).

Hi

thanks for the clue. I appreciate you taking the time to answere. I do not understand however how I can make this work in a sql loader control file.

Pointing out the "mm is month not minutes" is a help.

I guess I would need to have the '10:18:22.4' be a variable in

select to_date('10:18:22.4','hh:mm:ss:d') from dual; Received on Thu May 06 2004 - 13:07:00 CDT