---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-generate-series-time.md
cuppy_section: docs
cuppy_doc: 8DXV-MXRB
cuppy_doc_uuid: 3aeb436c-1716-4e53-94ba-5abd6db0f074
cuppy_permalink: https://cuppy.io/salesforce/d/8DXV-MXRB
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/array-generate-series-time
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: e3044b69a700915b789ed290843793bc72c0da0fe644a6246890cd115152aa0a
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> 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)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/generate-series-time.html) 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](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/generate-series-time.html#examples) for additional examples. They also apply to `array_generate_series`.

*   [Array Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/arrays.html)
*   [`ARRAY_GENERATE_SERIES` (Numerical)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/array-generate-series.html) - the numerical version of this function
*   [`generate_series` (Time-based)](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/generate-series-time.html) - the set-returning version of this function


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->