Oracle获取时间段内日期
SELECT TO_CHAR((TO_DATE('2022-01-01', 'yyyy-MM-dd') + ROWNUM - 1),'YYYY-MM-DD') as daylist
FROM DUAL
CONNECT BY ROWNUM <=
trunc(to_date('2022-03-31', 'yyyy-MM-dd') -
to_date('2022-01-01', 'yyyy-MM-dd')) + 1
SELECT TO_CHAR((TO_DATE('2022-01-01', 'yyyy-MM-dd') + ROWNUM - 1),'YYYY-MM-DD') as daylist
FROM DUAL
CONNECT BY ROWNUM <=
trunc(to_date('2022-03-31', 'yyyy-MM-dd') -
to_date('2022-01-01', 'yyyy-MM-dd')) + 1