RE: given day of the year.

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 15 Feb 2005 08:03:13 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A9735A@exchsen0a1ma>

Jaffar,

Try

select to_date('0101'||to_char(sysdate,'yyyy'),'mmddyyyy') + 100 from dual

Tom

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

From: Jaffar_DBA [mailto:sjaffarhussain_at_gmail.com] Sent: Tuesday, February 15, 2005 7:45 AM 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 - 08:06:03 CST