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.

1ARRAY_GENERATE_SERIES(<start>, <stop>, <step>)

• <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.

1SELECT ARRAY_GENERATE_SERIES('2017-01-01'::date, '2017-03-01'::date, '1 month'::interval);

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

1SELECT ARRAY_GENERATE_SERIES('2017-01-01 01:02:03'::timestamp, '2017-03-01 01:02:03'::timestamp, '1 month'::interval);

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