Re: sql question - need help on julian date conversion

From: Dave Fowler <dbf57_at_earthlink.net>
Date: Sun, 03 Jun 2001 23:34:49 GMT
Message-ID: <tQzS6.17814$651.1332257@newsread1.prod.itd.earthlink.net>

Mark,
Try using DDD format for your "julian" day of year. eg. select to_char(to_date('1999031','YYYYDDD'),'MM/DD/YYYY') from dual hth
Dave Fowler

"Mark Price" <msprice_at_worldnet.att.net> wrote in message news:0dxS6.63462$4f7.4793747_at_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 - 18:34:49 CDT