SELECT ( to_date(‘2014-03-28 00:00‘,‘yyyy-mm-dd hh24:mi‘)+ (LEVEL-1)/24)   AS MONITORTIME,
LEVEL lv
  FROM DUAL
CONNECT BY LEVEL <=
           ROUND((trunc(to_date(‘2014-03-28 23:00‘,‘yyyy-mm-dd hh24:mi‘),‘HH24‘) - to_date(‘2014-03-28 00:00‘,‘yyyy-mm-dd hh24:mi‘)) * 24 +1)

oracle 生成整时数据,布布扣,bubuko.com

oracle 生成整时数据