企鹅交流群 127591054
ORACLE
select date '2017-11-11' + level - 1 ddate, level from dual connect by level < date '2017-11-30' - date '2012-11-11' + 2
DB2
with temp1(col1)as
(
values(date('2005-09-03'))
union all
select col1 + 1 DAY from temp1 where col1 +1 DAY <= date('2006-02-01')
)
select * FROM TEMP1;
