Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLLOAD - inserting 1999 DATEs
Try checking the NLS_DATE_FORMAT variable to see how it's set.
Try changing to NLS_DATA_FORMAT = DD-MON-YYYY (or RR, or RRRR).
HTH wolf
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 - 08:51:44 CST