Re: import date

Two things you can do:

In the source-file : Search "00.00.0000" and replace it with a date like "01.01.1900"

or import the data into a temp table with a varchar2 field and update all data after the sql-loader has run. After that you insert the data into the original table.

Have a nice day
  Gerd Volberg
  Opitz&Partner GmbH

Andreas Lommel wrote:

> 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 - 12:19:17 CET