SELECT TO_CHAR(TO_DATE('20190401', 'YYYYMMDD') + ROWNUM - 1,'YYYYMMDD') AS DATE_LIST
FROM DUAL
CONNECT BY ROWNUM <= TRUNC(TO_DATE(TO_CHAR(SYSDATE
Oracle生成日期列表
最新推荐文章于 2022-02-23 15:11:59 发布
SELECT TO_CHAR(TO_DATE('20190401', 'YYYYMMDD') + ROWNUM - 1,'YYYYMMDD') AS DATE_LIST
FROM DUAL
CONNECT BY ROWNUM <= TRUNC(TO_DATE(TO_CHAR(SYSDATE