mirror of
https://github.com/SyncrowIOT/data.git
synced 2025-07-09 22:57:19 +00:00
5 lines
173 B
SQL
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; |