Oracle获取两个日期之间的时间列表

?

select to_date('2009-08-01 10:00:00','yyyy-mm-dd hh24:mi:ss') + (rownum - 1)/24

from dual

connect by rownum<=

(

trunc(to_date('2009-08-01 12:00:00','yyyy-mm-dd hh24:mi:ss'), 'hh24')

-

trunc(to_date('2009-08-01 10:00:00','yyyy-mm-dd hh24:mi:ss'), 'hh24')

)*24 + 1