RE: given day of the year.

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 15 Feb 2005 12:07:39 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87C62@irvmbxw02>

You can also use the DDD date format.

SQL> select to_date ('1', 'DDD') as first_of_year,

  2     to_date ('2', 'DDD') as second_of_year,
  3     to_date ('100', 'DDD') as hundredth_of_year

  4 from dual ;

FIRST_OF_YEAR SECOND_OF_YEAR HUNDREDTH_OF_YEAR
-------------------- -------------------- --------------------
 2005/01/01 00:00:00 2005/01/02 00:00:00 2005/04/10 00:00:00

-----Original Message-----

Jaffar_DBA

Could any one give me the script or sql for the following requirements:

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.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 15 2005 - 15:10:37 CST