Re: sqlldr date data

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 Sat Sep 30 2000 - 16:42:30 CDT