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;
...
原创
2022-04-12 09:55:28 ·
669 阅读 ·
0 评论