distanceN

导航

oracle获取连续时间

SELECT rownum, (to_date('2015-01-01', 'yyyy-mm-dd') + rownum - 1) AS show_time
FROM dual
CONNECT BY rownum < to_date('2015-02-27', 'yyyy-mm-dd') - to_date('2015-01-01', 'yyyy-mm-dd') + 1;

posted on 2017-07-19 11:28  distanceN  阅读(343)  评论(0)    收藏  举报