Re: date -field import

From: Davide Saya <dvdsya_at_uol.it>
Date: Fri, 12 Nov 1999 21:04:27 +0100
Message-ID: <80hs1g$p5$1@serv1.iunet.it>

I had the same problem recently.
I suggest you should use a condition in your control file

insert into .......
....
( order_date position (1: 10) DATE 'dd.mm.yyyy' nullif '00.00.0000',

........
)

I am not completely sure about the sintax, look in Server Utility Handbook if you have problems.

Andreas Lommel ha scritto nel messaggio <38294499.7520724_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 Fri Nov 12 1999 - 14:04:27 CST