Translate week number to date of the week.
Date: Tue, 27 Jan 2009 08:58:17 -0800 (PST)
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