Julian date conversion

[omacron]

Hi

I need to do a conversion of a julian date in a SQL script. Meaning convert a julian date to a calendar date. Is there a way of doing this?

thanks

 

[SantaMufasa]

Absolutely, Omacron.

To ensure that we give you the answer you are looking for, can you post some sample input and its counterpart output?

Here, for example is a conversion of TODAY (in Julian) to TODAY in default format:

select to_date(2454743,'j') from dual;

TO_DATE(2
---------
03-OCT-08

Let us know if this is useful.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”