SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2023-01','YYYY-MM'), ROWNUM - 1), 'YYYY-MM') AS fmonth FROM DUALCONNECT BY ROWNUM <= CEIL(MONTHS_BETWEEN(TO_DATE('2023-11', 'YYYY-MM'), TO_DATE('2023-01','YYYY-MM'))+1)```oracle查询开始时间和结束时间之间的连续月份
深耕网站建设、视觉设计与SEO优化的一线实战洞察。
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2023-01','YYYY-MM'), ROWNUM - 1), 'YYYY-MM') AS fmonth FROM DUALCONNECT BY ROWNUM <= CEIL(MONTHS_BETWEEN(TO_DATE('2023-11', 'YYYY-MM'), TO_DATE('2023-01','YYYY-MM'))+1)```