Oracle 查询时间段内所有日期
SELECT ROWNUM, TO_CHAR(TO_DATE('2020-11-01', 'yyyy-mm-dd') + ROWNUM - 1, 'yyyy-mm-dd') dates
FROM DUAL
CONNECT BY ROWNUM <= (TO_DATE('2020-11-10', 'yyyy-mm-dd')
- TO_DATE('2020-11-01', 'yyyy-mm-dd')) + 1
运行结果:
Oracle 查询时间段内所有日期
SELECT ROWNUM, TO_CHAR(TO_DATE('2020-11-01', 'yyyy-mm-dd') + ROWNUM - 1, 'yyyy-mm-dd') dates
FROM DUAL
CONNECT BY ROWNUM <= (TO_DATE('2020-11-10', 'yyyy-mm-dd')
- TO_DATE('2020-11-01', 'yyyy-mm-dd')) + 1
运行结果: