|
-
select to_date('01-JAN-&YYYY') + (&wk -1)*7 + r - 1
from dual , ( select rownum r from tab where rownum < 7 )
where to_char(to_date('01-JAN-&YYYY') +(&wk -1)*7 + r -1 , 'DY') = 'MON'
You might have to change the logic to derive the first day of the first week in the given year and use that instead of '01-JAN-&YYYY'.
This is the closest i could get..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|