Convert Date Into Week Range

Firstly Lets See How To Get Week Of The Year. Following Query Can Be Used To Get This

SELECT to_char(sysdate,'WW') FROM Dual;

Now Lets Get The Week Range

SELECT TO_CHAR (TRUNC (SYSDATE, 'IYYY') + ((TO_CHAR (SYSDATE, 'WW') - 1) * 7), 'DD-MON-RR')
|| ' to '
|| TO_CHAR (TRUNC (SYSDATE, 'IYYY') + ((TO_CHAR (SYSDATE, 'WW')) * 7)-1, 'DD-MON-RR')
FROM Dual;

He Output of Above Query For Date 29-Nov-2008 is 24-NOV-08 to 30-NOV-08