SELECT to_char(to_date('2018-08-01',
'YYYY-MM-DD') + rownum - 1,
'YYYY-MM-DD') day_id
FROM dual
CONNECT BY rownum <= trunc(to_date('2018-12-31',
'yyyy-mm-dd') - to_date('2018-08-01',
'yyyy-mm-dd')) + 1;
SELECT trunc(SYSDATE + LEVEL)
FROM dual
CONNECT BY LEVEL <= 12;
使用CONNECT BY生成一个日期列表
最新推荐文章于 2024-10-12 08:22:34 发布