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;