Re: Converting Legacy Date Fields

From: Mohamed Buhari <mbuhari_at_assigncorp.com>
Date: 14 Jan 2000 15:01:33 EST
Message-ID: <387F8025.60E948AB@assigncorp.com>

Hi,

Just load your data into a temporary table without conversion. Your "YYJJJ" column must be VARHCAR2. After loading the data, using a PL/SQL program, convert this YYJJJ actual year using to_date(......,'J') function and insert into your master table. For 'J' Julion conversion in oracle, refer to to_date and to_char functions

Ron Franks 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
Received on Fri Jan 14 2000 - 14:01:33 CST