Translate week number to date of the week.

   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