Oracle 连续时间生成

连续的日生成

SELECT to_char(SYSDATE - LEVEL + 1, 'yyyy-mm-dd') dates FROM DUAL connect BY LEVEL <= 7

连续小时

select Rownum,trunc(sysdate,'hh') + rownum / 24 past24 from dual connect by rownum<=24

连续周

SELECT TRUNC((TO_DATE('2019-4-23','yyyy-mm-dd')-(7-Rownum)*7),'iw') serialtime FROM DUAL CONNECT BY rownum <= 7

连续的月份生成

select to_char(add_months(start_date, (level - 1)), 'yyyy-mm') dates
from (select add_months(trunc(sysdate, 'mm'), -5) as start_date,
             add_months(trunc(sysdate, 'mm'), 1)  as end_date
      from dual)
connect by level < = months_between(end_date, start_date))

连续的年份生成

SELECT to_char(add_months(trunc(sysdate, 'y'), -5 * 12), 'yyyy') - 1 + level dates
FROM dual
CONNECT BY level <=
           months_between(trunc(trunc(sysdate, 'y'), 'yyyy'), trunc(add_months(trunc(sysdate, 'y'), -5 * 12), 'yyyy'))/12 + 1
           ```