本篇博客转载jumtre的博客https://blog.csdn.net/jumtre/article/details/46345733
转载只为方便学习查询. 如有侵权请联系删除.
获取日期列表:
SELECT TO_CHAR(TO_DATE('2014-10-01', 'yyyy-MM-dd') + ROWNUM - 1, 'yyyyMMdd') as daylist
FROM DUAL
CONNECT BY ROW
本篇博客转载jumtre的博客https://blog.csdn.net/jumtre/article/details/46345733
转载只为方便学习查询. 如有侵权请联系删除.
获取日期列表:
SELECT TO_CHAR(TO_DATE('2014-10-01', 'yyyy-MM-dd') + ROWNUM - 1, 'yyyyMMdd') as daylist
FROM DUAL
CONNECT BY ROW