RE: given day of the year.

From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
To: "'sjaffarhussain@xxxxxxxxx'" <sjaffarhussain@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
Date: Tue, 15 Feb 2005 08:03:13 -0500

Jaffar,

Try 

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

Tom

-----Original Message-----
From: Jaffar_DBA [mailto:sjaffarhussain@xxxxxxxxx] 
Sent: Tuesday, February 15, 2005 7:45 AM
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....
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: given day of the year.
From: David Kurtz

RE: given day of the year.

Other related posts: