Translate week number to date of the week.

From: CrazyKarma <>
Date: Tue, 27 Jan 2009 08:58:17 -0800 (PST)
Message-ID: <>


   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 Received on Tue Jan 27 2009 - 10:58:17 CST

Original text of this message