Re: sqlldr date data

Thanks Rich_at_home. MI not MM, that was it.

--Luke.

"@home" wrote:
>
> Luke,
>
> Interesting, I would expect the server to complain about the number of
> parameters passed in the to_date function which is defined as
> to_date(string, 'format_specifier'). The exception is if the string is in
> the default fomat which, unless you've changed it for your installation, is
> DD-MON-YY. I've loaded dates in the past with this format ...
>
> ...
> TIMESTAMP DATE "RR-MM-DD HH:MI:SS",
> ...
>
> But I must say that I've usually used the 4-digit year format. Also,maybe
> you mistyped the line from your code, but you seemed to use MM as the format
> specifier instead of MI for minutes.
>
> Rich
>
> "Lukasz Szyrmer" <lukasz_at_gate.octava.com.pl> wrote in message
> news:8r2fko$gk3$2_at_news.tpi.pl...
> > Hi,
> >
> > What is the column definition format for importing dates into oracle from
> > CSV's?
> >
> > I have a date column looking like this
> > ...,
> > TIMESTAMP "TO_DATE('RR-MM-DD HH:MM:SS')",
> > ....
> > presumably running the SQL function TO_DATE which should
> > recognize which year the data is in if it is in the format of 00-3-7
> > 00:00:00. But sqlldr claims the date cannot be year 0 even though it can
> > be of the range -4000 to +9999.
> >
> > What should I tell it to import data like this?
> >
> > Thanks,
> > Luke
Received on Mon Oct 02 2000 - 06:21:17 CDT