Re: Dates with SQLLoader
From: iks <oopsik_at_spoczta.onet.pl>
Date: Wed, 15 Nov 2000 18:58:17 +0100
Message-ID: <8uuitj$onk$1_at_orfika.office.polbox.pl>
Date: Wed, 15 Nov 2000 18:58:17 +0100
Message-ID: <8uuitj$onk$1_at_orfika.office.polbox.pl>
"Sandro PIAZZINI" <sandro.piazzini_at_programmer.net> wrote in message
news:8utljn$rs0$1_at_news5.isdnet.net...
> Hello.
>
> I try to load a .DAT file into my database with Personal Oracle.
> But a date field contains blank characters sometimes, or real dates
> sometimes.
>
> How to use SQLLoader for this field ?
> I don't want to replace blank characters with a dummy date like "01011990"
Hi,
Try following:
.....
YOUR_DATE POSITION(74:81) DATE "YYYYMMDD" NULLIF(BILL_DATE=BLANKS),
....
YOUR_DATE will be NULL if it is empty in source datafile.
Regards,
x Received on Wed Nov 15 2000 - 18:58:17 CET