Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLLOAD - inserting 1999 DATEs

Re: SQLLOAD - inserting 1999 DATEs

From: Trevor <Jacksont_at_commnet.edu>
Date: Mon, 24 Jan 2000 14:05:28 GMT
Message-ID: <86hm74$dl3$1@nnrp1.deja.com>


Appreciate your responses. I am all set.

thanks!
Trevor

In article <38888098.7B996D88_at_psmfc.org>,   cbantzer <christian_bantzer_at_psmfc.org> wrote:
> 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.
>

--
Trevor

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 08:05:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US