Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr & date?
By default, sqlldr will use the date format specified in the init.ora file
when loading character strings into date columns. Alternatively you can set
NLS_DATE_FORMAT in your OS session before running sqlldr, or specify a
datatype and sql string following the column name (i.e., DATEOF DATE
"DD-MON-RR")
"Glen A Stromquist" <glen_stromquist_at_nospam.yahoo.com> wrote in message
news:M3Bp9.8499$wU3.351219_at_news0.telusplanet.net...
> > On Thu, 10 Oct 2002 22:25:38 GMT, Glen A Stromquist
> > <glen_stromquist_at_nospam.yahoo.com> wrote:
> >
> >>control file LOAD.CTL:
> >>
> >>load data
> >>infile file.csv
> >>insert into table schema.table
> >>fields terminated by ","
> >>(DATEOF "DD-MON-YY",
> >>NUM1,
> >>NUM2,
> >>NUM3,
> >>NUM4,
> >>NUM5,
> >>NUM6,
> >>NUM7)
> ---snipped
>
>
> I ended up just taking the "DD-MON-YY" out of the ctl file and it worked.
> I'm still a bit mystified though, as I'm sure thats what I tried in the
1st
> place!
Received on Sun Oct 13 2002 - 16:02:08 CDT