Re: Date problem ---- SOS

twod_at_tdl.com (Ian Parkin) wrote:
>: e.g. 10175 = 09-Nov-1995
>
>Well, 'select to_date('01-Jan-69') + 10175 from dual;' gives '10-NOV-96'.
>
>Hope this helps.
>
>IAP
Which would mean that the "ZERO" date would be 31-DEC-68. Therefore

select to_date('31-Dec-68') + YourJulianDate from dual;

will give you the corresponding date.

-- 
 
Mike Morgan
Technology Integration Services - Unix DBA

email: mike.morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705  USA
(608)845-4661

"Murphy's Law of computing:  Anything that can go wrSegmentation 
fault(coredump)"
*******************************************************