by 문선린 [2014.03.26 17:35:50]
SELECT sdt + (LEVEL - 1) / 24 dt FROM (SELECT TO_DATE('20140326', 'yyyymmdd') sdt, TO_DATE('20140327', 'yyyymmdd') edt FROM dual) CONNECT BY LEVEL <= (edt - sdt + 1) * 24 ;