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;
oracle获取连续时间
原文：http://www.cnblogs.com/distanceN/p/7204802.html
