DB2获取日期区间所有日期

直接返回日期区间中所有的日期

WITH DATATEMP(DATELIST) AS (
VALUES(FIRST_DAY(CURRENT DATE))
UNION ALL 
SELECT DATELIST + 1 DAY  FROM DATATEMP 
WHERE DATELIST +1 DAY <= LAST_DAY(CURRENT DATE)
) 
SELECT to_char(DATELIST,'yyyy-MM-dd') FROM DATATEMP;