Re: Julian to date conversion

Try separating the decimal from the days. Like this: "to_date(2451544,'j') + .46"

HTH
 James

In article <BZ2B5.31801$Z2.469920_at_nnrp1.uunet.ca>,   "S Paquin" <stephane.paquin_at_nospam.ispatnet.com> wrote:
> Hi !
> I am trying to convert a julian date to character and it seems that J
> format doesn't allow fractional days. Anybody has a suggestion ?
>
> For example, I try to convert Julian day 2451544.46 to the
> corresponding date/time 31-DEC-1999 15:55:32 in a sql statement.
>
> Any help will be appreciated.
>
> Stephane
>
>

--
Life is complex; it has real and imaginary parts.


Sent via Deja.com http://www.deja.com/
Before you buy.