SQL
Generate a Sequence of Dates (PostgreSQL)
Learn to efficiently generate a continuous series of dates in PostgreSQL using `generate_series`, perfect for time-series analysis, reporting, and filling data gaps.
SELECT
generate_series('2023-01-01'::date, '2023-01-31'::date, '1 day'::interval) AS date_series;
How it works: This PostgreSQL-specific snippet utilizes the powerful `generate_series` function to create a continuous sequence of dates. It takes a start date, an end date, and an interval (e.g., '1 day') to produce a row for each date in the specified range. This is incredibly useful for time-series analysis, ensuring all dates are represented even if no data exists, or for building calendar tables.