Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!195.96.0.7.MISMATCH!newsfeed.utanet.at!news.germany.com!proxad.net!feeder1-2.proxad.net!212.27.60.64.MISMATCH!cleanfeed3-b.proxad.net!nnrp8-2.free.fr!not-for-mail
From: "Michel Cadot" <micadot{at}altern{dot}org>
Newsgroups: comp.databases.oracle.server
References: <a4f012e5-0ae4-426d-98bc-e23751344f35@f40g2000pri.googlegroups.com>
Subject: Re: Translate week number to date of the week.
Date: Tue, 27 Jan 2009 18:32:05 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
Lines: 30
Message-ID: <497f4513$0$22696$426a74cc@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 27 Jan 2009 18:32:03 MET
NNTP-Posting-Host: 82.67.171.166
X-Trace: 1233077523 news-2.free.fr 22696 82.67.171.166:3454
X-Complaints-To: abuse@proxad.net
Xref:  news.cambrium.nl


"CrazyKarma" <skalki@gmail.com> a écrit dans le message de news: 
a4f012e5-0ae4-426d-98bc-e23751344f35@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