Re: Load date in 'MM/DD/YYYY' format by SQL*LOADER

From: Andrew Hardy <Andrew.Hardy_at_BGTechnology.com>
Date: Tue, 17 Oct 2000 09:38:16 +0100
Message-ID: <8sh35h$mp$1@sun-cc204.lboro.ac.uk>

Maggie,

What error are you getting? What version of Oracle?

I think that you can also get problems if the date format in the file does not match the NLS_DATE_FORMAT in which case you might need to use the TO_DATE function, something like:

AVAILABILITY_DT DATE 'dd-mon-yy'
"to_date(:AVAILABILITY_DT,'MM/DD/YYYY')"

Andy

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 - 03:38:16 CDT