oracle获取连续时间时间:2023-03-09 00:16:39 SELECT rownum, (to_date('2015-01-01', 'yyyy-mm-dd') + rownum - 1) AS show_time FROM dualCONNECT BY rownum < to_date('2015-02-27', 'yyyy-mm-dd') - to_date('2015-01-01', 'yyyy-mm-dd') + 1;