Oracle获取时间或者月份列表

SQL获取时间列表

SELECT TO_CHAR(TO_DATE('2012-02-20','YYYY-MM-DD')+ROWNUM-1  ,'YYYY-MM-DD') DAY_ID  

FROM DUAL

CONNECT BY ROWNUM<=trunc(to_date('2012-03-03', 'yyyy-mm-dd')-to_date('2012-02-20', 'yyyy-mm-dd'))+1

SQL获取月份列表

SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2012-01','YYYY-MM'),ROWNUM-1),'YYYY-MM') DAY_ID

FROM DUAL

CONNECT BY ROWNUM<=months_between (to_date('2013-01', 'yyyy-mm'),to_date('2012-01', 'yyyy-mm'))+1