Files
syncrow-data/dim_date/dim_date.sql
Dona Maria Absi 99002f10dc new tables
2025-01-28 21:15:28 +03:00

5 lines
173 B
SQL

SELECT generate_series(
DATE '2024-01-01', -- Start date
DATE '2065-12-31', -- End date
INTERVAL '1 day' -- Step size
)::DATE AS daily_date;