select t.DAY_ID from (
SELECT TO_CHAR(TO_DATE(‘2018-01-01’, ‘YYYY-MM-DD’) + ROWNUM - 1, ‘YYYY-MM-DD’) DAY_ID FROM DUAL
CONNECT BY ROWNUM <TO_DATE(‘2023-01-01’, ‘YYYY-MM-DD’) - TO_DATE(‘2018-01-01’, ‘YYYY-MM-DD’) + 1
) t
SELECT TO_CHAR(ADD_MONTHS(TO_DATE(‘2023-01’,‘YYYY-MM’), ROWNUM - 1), ‘YYYY-MM’) AS fmonth FROM DUAL
CONNECT BY ROWNUM <= CEIL(MONTHS_BETWEEN(TO_DATE(‘2023-11’, ‘YYYY-MM’), TO_DATE(‘2023-01’,‘YYYY-MM’))+1)```
oracle查询时间段范围内的日期
于 2024-01-18 12:21:29 首次发布