RE: given day of the year.

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 15 Feb 2005 13:49:35 +0100
Message-Id: <20050215124938.CCFCE50C29A@ha-smtp2.tiscali.nl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jaffar_DBA
Sent: Tuesday, February 15, 2005 13:45
To: oracle-l_at_freelists.org
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....
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 15 2005 - 07:52:28 CST