1 2 3 4 5 6 7 8 9 10 11 12 | SELECT dt FROM ( SELECT s + LEVEL - 1 dt , TRUNC(TRUNC(s + LEVEL - 1, 'mm' ), 'd' ) sdt FROM ( SELECT TO_DATE( '20221001' , 'yyyymmdd' ) s , TO_DATE( '20221231' , 'yyyymmdd' ) e FROM dual ) CONNECT BY LEVEL <= e - s + 1 ) WHERE CEIL((dt - sdt) / 7) IN (2, 4, 6) -- 주차 AND TO_CHAR(dt, 'd' ) = 2 -- 요일 ; |