Re: Difficult Sql Loader problem with RRRR date format

From: Stuart Turton <sturton_at_maderich.demon.co.uk>
Date: Sun, 14 Apr 2002 19:33:20 GMT
Message-ID: <3CB9DB7A.5020409@maderich.demon.co.uk>

What about
Delimited by '|'
(
joe char
, topic char
, expire Date 'MM-DD-YYYY' NULLIF (expire = "01-01-0001") )

or could be
,expire Date 'MM-DD-YYYY'
NULLIF (expire=TO_DATE('01-01-0001','MM-DD-YYYY'))

SQL*Loader Control File Reference.

julio wrote:

> We have an 8.1.6 database on Sun server running Sun 2.7. We have an NLS date
> format of MM-DD-RRRR
>
> We have a table that is loaded from a text file via SQL Loader
> Table:
>
> Name varchar
> Topic varchar
> Expire date

...

>
>
Received on Sun Apr 14 2002 - 14:33:20 CDT