Re: HELP - Convert julian date to gregorian?
From: Wolfgang Breitling <breitliw_at_cadvision.com>
Date: 1995/09/30
Message-ID: <44ibfo$26oc_at_huey.cadvision.com>#1/1
Date: 1995/09/30
Message-ID: <44ibfo$26oc_at_huey.cadvision.com>#1/1
In article <sparky.2.00C2F918_at_sparky.slip.iglou.com>,
sparky_at_sparky.slip.iglou.com (Sparky) wrote:
>I am trying to build or find a routine to convert a julian date to
>gregorian. Does anyone know of such a routine for Oracle 7?
>
>Thanks for any help.
Try
select to_char(to_date(1995365,'yyyyddd'),'mm/dd/yyyy') from dual Received on Sat Sep 30 1995 - 00:00:00 CET