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).
> > --
> > TomekB
>
> And is there an explanation for the 'interesting' usage of mixed isngle
> and double quotes?

Why 'intersting' ??
Doesn't say that HH:MI:SS then '.' and then DD is expected in field data ;-) ?

last field in data line:
dlls001,0x000123456,545678,GMT-4:00-Eastern-DST,04/16/2004,10:18:22.4

--
TomekB