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;| 搜索 |
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;