Processing multiple date formats length for the same column.

Processing multiple date formats length for the same column.

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Jim' on June 08, 2001 at 13:20:36 EST:

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, or at least handle the leading non-existent zeros?

Follow Ups:

Re: Processing multiple date formats length for the same column. Jim 08:10:18 6/13/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : 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, or at least handle the leading non-existent zeros?