Re: Help with SQLLDR - how to use a control file to process multiple date formats for the same column?

Hi,

[Quoted] [Quoted]  Pl. try following format in control file.

 RETURN_DATE DATE "LPAD(TO_CHAR(:RETURN_DATE),6,'0')"  With regards,

 CHIRAG SHAH
 Oracle Administator

jim_esti_at_hotmail.com (Jim) wrote in message news:<f0e3dc0b.0106080857.641b914e_at_posting.google.com>...
> Hi,
>
> In my control file I process dates with
> RETURN_DATE date "YYMMDD" NULLIF RETURN_DATE = '0'. Similar code
> exists for the other date related columns.
> This does the trick for about 200 of the 20000 records. The date is
> some times 6 digits and sometimes 5, 4 or 3 digits. As the date could
> be 000101 (January 01, 2000) - but the text file just contains the
> number 101 (the extract from the old DOS system drops the leading
> zeros).
>
> How can make the control file to process multiple date formats for the
> same column?
Received on Sat Jul 21 2001 - 23:51:02 CEST