Oracle 取某100天的每一天的日期

SELECT TO_DATE('2016-01-01', 'yyyy-MM-dd') + ROWNUM - 1 as daylist,TO_DATE('2016-01-01', 'yyyy-MM-dd') + ROWNUM as daylists
FROM DUAL
CONNECT BY ROWNUM <=100

posted @ 2016-08-08 09:17  向阳的影子  阅读(1575)  评论(0编辑  收藏  举报