Re: Translate week number to date of the week.
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 27 Jan 2009 18:32:05 +0100
Message-ID: <497f4513$0$22696$426a74cc_at_news.free.fr>
Date: Tue, 27 Jan 2009 18:32:05 +0100
Message-ID: <497f4513$0$22696$426a74cc_at_news.free.fr>
"CrazyKarma" <skalki_at_gmail.com> a écrit dans le message de news:
a4f012e5-0ae4-426d-98bc-e23751344f35_at_f40g2000pri.googlegroups.com...
| All,
|
| Is there a quick way to convert week number ( of the year) to start
| date of that week?
|
| EX: If I pass week number as 1 then it should return 1/1/2009
| if I pass week number as 7 then it should return 2/8/2009.
|
| This gets if I know the date
|
| select trunc(sysdate, 'd') from dual
|
| but I need something equivalet to that as
|
| select FN(7) from dual;
|
| Thanks a bunch
maybe:
select greatest(trunc(sysdate,'year'),trunc(trunc(sysdate,'year'),'iw')+7*(&input-1))
from dual
/
Regards
Michel
Received on Tue Jan 27 2009 - 11:32:05 CST