RE: given day of the year.
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <sjaffarhussain@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 15 Feb 2005 13:49:35 +0100
what about truncate the current date to the 1st of january, and then add the
number?
kind regards,
Lex.
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Jaffar_DBA
Sent: Tuesday, February 15, 2005 13:45
To: oracle-l@xxxxxxxxxxxxx
Subject: given day of the year.
Hello list,
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.
--
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia
------------------------
It is your atittude,
not your aptitude
that determins your ultitude....
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
