select to_char(to_date(20110512, 'yyyy-mm-dd hh24:mi:ss') + (rownum - 1) / 24, 'hh24:mi') Hour from dual connect by rownum <= 24 order by hour