SQLLOAD - inserting 1999 DATEs

From: Trevor <Jacksont_at_commnet.edu>
Date: Fri, 21 Jan 2000 14:14:23 GMT
Message-ID: <869pji$t5$1@nnrp1.deja.com>

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 - 08:14:23 CST