Re: given day of the year.

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 15 Feb 2005 05:55:59 -0700
Message-Id: <6.2.0.14.2.20050215055435.02631fe0@pop.centrexcc.com>

to_char(to_date(julian date, julian date format),gregorian date format)

At 05:45 AM 15/02/2005, Jaffar_DBA wrote:

>If I need to know the 100th day of this year, like, If I pass value
>100, want to extract the 100th day of the given year. Sunday 21,
>March, 2005. something like that.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 15 2005 - 07:58:50 CST