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