SELECT DATE
FROM ( ( WITH date_series AS
( SELECT DATE(GENERATE_SERIES(TO_DATE('2020-01-01', 'YYYY-MM-DD'), TO_DATE('2020-12-31', 'YYYY-MM-DD'),'1 day')) AS DATE
)
SELECT DATE
FROM date_series ) ) G

일별 출력




SELECT TO_CHAR(DATE,'YYYY-MM') AS DT
FROM ( ( WITH date_series AS
( SELECT DATE(GENERATE_SERIES(TO_DATE('2020-01-01', 'YYYY-MM-DD'), TO_DATE('2020-12-31', 'YYYY-MM-DD'),'1 MONTH')) AS DATE
)
SELECT DATE
FROM date_series ) ) G


월별 출력