select to_date('2008' || '0101', 'yyyymmdd') + rownum - 1 rq,
to_char(to_date('2008' || '0101', 'yyyymmdd') + rownum - 1, 'day')
from (select rownum
from dual
connect by rownum <= to_date('2008' || '1231', 'yyyymmdd') -
to_date('2008' || '0101', 'yyyymmdd') + 1)[@more@]
to_char(to_date('2008' || '0101', 'yyyymmdd') + rownum - 1, 'day')
from (select rownum
from dual
connect by rownum <= to_date('2008' || '1231', 'yyyymmdd') -
to_date('2008' || '0101', 'yyyymmdd') + 1)[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8190463/viewspace-1003492/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8190463/viewspace-1003492/