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....
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
