SELECT to_date('2007-02-01', 'yyyy-mm-dd') + rownum / 24 AS hour
FROM dual
CONNECT BY rownum < (to_date('2007-02-02', 'yyyy-mm-dd') - to_date('2007-02-01', 'yyyy-mm-dd')) * 24;
转载于:https://www.cnblogs.com/geping/p/8547952.html
SELECT to_date('2007-02-01', 'yyyy-mm-dd') + rownum / 24 AS hour
FROM dual
CONNECT BY rownum < (to_date('2007-02-02', 'yyyy-mm-dd') - to_date('2007-02-01', 'yyyy-mm-dd')) * 24;
转载于:https://www.cnblogs.com/geping/p/8547952.html