下边这个SQL是通过年份和周数来算出其所在日期的起始日期和结束日期
WITH PARAMS AS (SELECT TO_NUMBER(32) AS ZS,2014 NF FROM DUAL)
SELECT TO_CHAR((TRUNC(TO_DATE((SELECT NF FROM PARAMS) || '-01-01', 'YYYY-MM-DD'), 'YYYY') - 7) +
(7 - TO_CHAR(TRUNC(TO_DATE((SELECT NF FROM PARAMS) || '-01-01', 'YYYY-MM-DD'),'YYYY'), 'D') + 1) + ((SELECT ZS FROM PARAMS) - 1) * 7 + 1,'YYYY-MM-DD') FIRST_DAY,
TO_CHAR((TRUNC(TO_DATE((SELECT NF FROM PARAMS) || '-01-01', 'YYYY-MM-DD'),'YYYY') - 7) +
(7 - TO_CHAR(TRUNC(TO_DATE((SELECT NF FROM PARAMS) || '-01-01','YYYY-MM-DD'), 'YYYY'), 'D') + 1) + ((SELECT ZS FROM PARAMS) - 1) * 7 + 7,'YYYY-MM-DD') LAST_DAY
FROM DUAL