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')
-
trun...
原创
2012-06-21 11:15:18 ·
244 阅读 ·
0 评论