Re: Converting Legacy Date Fields

You can specify the input format for the date in the SqlLoader .CTL file Like this:

AGENCY_USE_DT DATE 'mmddyyyy' NULLIF AGENCY_USE_DT = BLANKS

the 'mmddyyy' is the format of the date info in the input file, it will be stored in Oracle's date format ( assuming you are using a true DATE datatype in the Oracle table - the NULLIF clause is needed for any blank dates in the input data, otherwise the record will be rejected)

After it is in Oracle Date format you can display it using any of Oracle's date formatting options...

hth,
John Greco

Ron Franks <Ron.Franks_at_trw.com> wrote:

>Does anyone know how to convert dates that are in the form YYJJJ, (where
>YY= year and JJJ = Julian date) into something that Oracle likes, such
>as "MMDDYY"? Here's my challenge: I'm migrating mainframe legacy data
>into Oracle tables using SQL*Loader. The date field blows up on me, so
>I need to somehow convert it during the loading process.
>
>Any advice is appreciated, thanks in advance.
>
>Ron.Franks_at_trw.com

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Jan 14 2000 - 15:16:01 CST