Re: HELP - Convert julian date to gregorian?
From: Debbie <d_shaver_at_testbed.swfpac.lmsc.lockheed.com>
Date: 1995/09/28
Message-ID: <44esro$pbr_at_butch.lmsc.lockheed.com>#1/1
Date: 1995/09/28
Message-ID: <44esro$pbr_at_butch.lmsc.lockheed.com>#1/1
If the data is in an oracle database, use the Oracle date functions. If the data is currently in a varchar2 field, convert it to a date field as follows:
converted_date := to_date(char_date,'dddyyyy')
or something thereabouts assuming the char date is in the format dddyyyy. Once the data is in a date field, it can be displayed in any of the valid date formats ex:
to_char(converted_date,'mm/dd/yyyy')
Hope This helps Received on Thu Sep 28 1995 - 00:00:00 CET