Re: SQLLOAD - inserting 1999 DATEs

try double quotes "
e.g.

DATE_COLUMN POSITION(62:72) DATE "DD-MON-YYYY" That works for me, and is the way it's in the docs (at least the 7.3 ones I have)

Christian

Trevor wrote:
>
> Hoping someone has come across this and can share any suggestions...
>
> On trying to load data from a file into a table in an oracle database,
> no matter what date format I use with the Date datatype in the control
> file, 1999 dates in the data file are inserted in the oracle table as
> 2099. I have tried all the following date formats in the control file
> and the load happens successfully except for inserting 2099...
>
> DATE_COLUMN POSITION(62:72) DATE 'DD-MON-YYYY'
>
> DATE_COLUMN POSITION(62:70) DATE 'DD-MON-RR'
>
> (where RR supposedly does that default oracle pivot to get the
> appropriate century).
>
> DATE_COLUMN POSITION(62:69) DATE 'YYYYMMDD'
>
> The control file syntax is:
>
> LOAD DATA
> INFILE "datafile.dat"
> REPLACE
> INTO TABLE test APPEND
> (DATE_COLUMN POSITION(62:72) DATE 'DD-MON-YYYY')
>
> Is there some option or syntax I can use to force SQLLOAD to load 1999
> dates and therefore not insert 2099 into the table?
>
> thanks!
>
> --
> Trevor Jackson
> JacksonT_at_commnet.edu
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jan 21 2000 - 09:51:52 CST