Oracle 获取时间段内的 日期列表 和时间列表

本文来自 http://xuwang840901.blog.163.com/blog/static/441696922010573261897/
获取日期

SELECT TO_CHAR(TO_DATE('2009-04-1','YYYY-MM-DD')+ROWNUM-1
,'YYYY-MM-DD') DAY_ID
FROM DUAL CONNECT BY ROWNUM<=trunc(to_date('2009-05-23', 'yyyy-mm-dd')-to_date('2009-04-1', 'yyyy-mm-dd'))+1

获取月份

SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2009-03','YYYY-MM'),ROWNUM-1),'YYYY-MM') DAY_ID FROM DUAL CONNECT BY ROWNUM<=months_between (to_date('2010-03', 'yyyy-mm'),to_date('2009-03', 'yyyy-mm'))+1