获取两个日期之间日期列表

企鹅交流群 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;