Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Load date in 'MM/DD/YYYY' format by SQL*LOADER
here's a line from one of my control files:
purchase_date position(14-21) DATE(8) 'YYYYMMDD',
hope it helps ya!
"Maggie" <maggiezhou_at_hotmail.com> wrote in message
news:8sg1di$8f6$1_at_web1.cup.hp.com...
> I have a data file that date in 'MM/DD/YYYY' such as '10/11/2000'. I
am
> trying to use sql loader to load the file into table.
> I wrote the control file including:
> AVAILABILITY_DT DATE NULLIF AVAILABILITY_DT="00000000"
>
> However, oracle can not take it. I did try to chang control to :
> AVAILABILITY_DT DATE 'MM/DD/YYYY' NULLIF AVAILABILITY_DT="00000000"
>
> It dosen't work either.
>
> So how can I modify the control file in order to take the date like
> 'MM/DD/YYYY' ?
> Please help.
>
>
>
Received on Tue Oct 17 2000 - 14:40:40 CDT