DB2数据库,返回两个日期区间的全部日期
with DATATEMP(DATELIST) as (
values(date('2020-01-03'))
union all
select DATELIST + 1 DAY from DATATEMP
where DATELIST +1 DAY <= date('2020-01-10')
)
select * FROM DATATEMP;
执行结果如下图:
DB2数据库,返回两个日期区间的全部日期
with DATATEMP(DATELIST) as (
values(date('2020-01-03'))
union all
select DATELIST + 1 DAY from DATATEMP
where DATELIST +1 DAY <= date('2020-01-10')
)
select * FROM DATATEMP;
执行结果如下图: