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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13964895/viewspace-740910/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13964895/viewspace-740910/