Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-generate-series-time.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

`ARRAY_GENERATE_SERIES` (Time-based)

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Generate an array of time-based values, from start to stop with a given step size.

<start>: The start value of the series. Can be of type DATE, TIMESTAMP, or TIMESTAMP WITH TIME ZONE.
<stop>: The end value of the series. Must be of the same type as <start>.
<step>: The step size as an INTERVAL. Unlike the numerical version of ARRAY_GENERATE_SERIES, the step size is always required for time-based series.

Returns an ARRAY containing the generated series of values.

This function is equivalent to the generate_series (Time-based) function, with the only difference that it returns an array instead of a set of rows. Read the documentation on generate_series (Time-based) for more details. All considerations also apply to array_generate_series with the following differences:

Generate an array of months between two dates.

returns ["2017-01-01","2017-02-01","2017-03-01"]

returns ["2017-01-01 01:02:03","2017-02-01 01:02:03","2017-03-01 01:02:03"]

Take a look at the generate_series examples for additional examples. They also apply to array_generate_series.

Array Functions
ARRAY_GENERATE_SERIES (Numerical) - the numerical version of this function
generate_series (Time-based) - the set-returning version of this function

ARRAY_GENERATE_SERIES (Time-based)

`ARRAY_GENERATE_SERIES` (Time-based)