WITH T AS (
SELECT TO_DATE('2017-01-01' ,'YYYY-MM-DD') AS FR_MM , TO_DATE('2017-04-01' ,'YYYY-MM-DD' ) TO_MM FROM DUAL
)
SELECT TO_CHAR( ADD_MONTHS(FR_MM,LEVEL-1) , 'MON-YYYY', 'NLS_DATE_LANGUAGE=ENGLISH') MM
FROM T
CONNECT BY LEVEL <= ( SELECT MONTHS_BETWEEN(TO_MM,FR_MM) + 1 FROM T)
by 문준
[2018.03.26 13:11:12]
감사합니다
by 마농
[2018.03.26 13:14:45]
SELECT TO_CHAR(ADD_MONTHS(sdt, LEVEL - 1), 'Mon-yyyy', 'nls_date_language=american') mon_yyyy
FROM (SELECT TO_DATE('2017-01-01', 'yyyy-mm-dd') sdt
, TO_DATE('2017-04-01', 'yyyy-mm-dd') edt
FROM dual)
CONNECT BY LEVEL <= MONTHS_BETWEEN(edt, sdt) + 1
;
by 문준
[2018.03.26 13:31:05]
감사합니다
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.