Re: Date problem ---- SOS
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/11/10
Message-ID: <48081d$2ea$1_at_mhafc.production.compuserve.com>#1/1
Date: 1995/11/10
Message-ID: <48081d$2ea$1_at_mhafc.production.compuserve.com>#1/1
Converting a Julian style date to any other date format should be easily
accomplished using Oracle date formats.
First, work out your start date in Oracle's proper Julian date format
(EG Select to_char(to_date('1-jan-69'),'J')
Then take that figure and add it to the number on the database, and convert
the result back from the Julian date to a standard date format :
Select to_date(to_char(10175 + nnnnnn),'J')
Gary
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Fri Nov 10 1995 - 00:00:00 CET