with t as(select rownum-1 rn from dual connect by rownum<=24), hoursbyday as (select to_date('2014/3/18 00:00:00', 'yyyy/mm/dd hh24:mi:ss') + (1+rn)/24 from t ) select * from hoursbyday