Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Julian to date conversion

Julian to date conversion

From: S Paquin <stephane.paquin_at_nospam.ispatnet.com>
Date: Fri, 29 Sep 2000 11:57:19 -0400
Message-ID: <BZ2B5.31801$Z2.469920@nnrp1.uunet.ca> 






    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
Received on Fri Sep 29 2000 - 10:57:19 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US