SELECT
(TRUNC(A.DT,'IW')-1) "STARTDATE"
,(TRUNC(A.DT,'IW')-1)+6 "ENDDATE"
FROM
(
SELECT
TO_DATE (20120112+1, 'YYYYMMDD') - LEVEL DT
FROM DUAL
CONNECT BY LEVEL <= 13 /* fromday - today 로 계산 */
)A
WHERE
A.DT >= TO_DATE('20111231','YYYYMMDD')
AND A.DT < TO_DATE('20120112','YYYYMMDD') + 1
GROUP BY (TRUNC(A.DT,'IW')-1)
|