Re: date - import

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Wed, 10 Nov 1999 19:31:51 GMT
Message-ID: <01bf2bc2$20880c60$a504fa80@mndnet>

Hi,

First of all the date value cannot be 00.00.0000. Are you giving an example of the format ?

If that is the case:
After the date column name, use the format to convert the string to a date: (
...
create_date 'dd.mm.yyyy' ,
...
...
)

Later !!!

Suresh Bhat
Oracleguru
www.oracleguru.net

Andreas Lommel <him_lommel_at_t-online.de> wrote in article <38294b62.9257070_at_news.btx.dtag.de>...
> Hi there, I want to import a date with SQL-Loader. The value is
> 00.00.0000, which stand for a standard date.
> Then there is a error message ORA-01847
> day of month must be between 1 and last day of month
> Cause: The day of the month listed in a date is invalid for the
> specified month. The day of the month (DD) must be between 1 and the
> number of days in that month.
> What can I do ???
>
>
Received on Wed Nov 10 1999 - 13:31:51 CST