Oracle获取两个日期之间的所有日期(年-月)
SELECT TO_CHAR(ADD_MONTHS(TO_DATE(‘2018-01’, ‘YYYY-MM’), ROWNUM - 1),‘YYYY-MM’) DAY_ID
FROM DUAL
CONNECT BY ROWNUM <=
MONTHS_BETWEEN(TO_DATE(‘2018-04’, ‘yyyy-mm’),
TO_DATE(‘2018-01’, ‘yyyy-mm’)) + 1
SELECT TO_CHAR(ADD_MONTHS(TO_DATE(‘2018-01’, ‘YYYY-MM’), ROWNUM - 1),‘YYYY-MM’) DAY_ID
FROM DUAL
CONNECT BY ROWNUM <=
MONTHS_BETWEEN(TO_DATE(‘2018-04’, ‘yyyy-mm’),
TO_DATE(‘2018-01’, ‘yyyy-mm’)) + 1