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

Home -> Community -> Usenet -> c.d.o.tools -> sql question - need help on julian date conversion

sql question - need help on julian date conversion

From: Mark Price <msprice_at_worldnet.att.net>
Date: Sun, 03 Jun 2001 20:36:12 GMT
Message-ID: <0dxS6.63462$4f7.4793747@bgtnsc06-news.ops.worldnet.att.net> 






I need to convert the following character data to an Oracle date.



For example, I need to convert '1999031' to a date type of '01/31/1999'. The
'031' is a julian date.



Any suggestions?



Thanks in advance....
Received on Sun Jun 03 2001 - 15:36:12 CDT












Original text of this message













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