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.