Generate Functions
GENERATE_DATE_ARRAY(<start_date/timestamp>, <end_date/timestamp> , INTERVAL <step_int> <date_part>)
Returns an array of date.
Supported date_part must be either DAY, MONTH, YEAR
The step_int parameter determines the increment used to generate dates.
GENERATE_TIMESTAMP_ARRAY(<start_timestamp>, <end_timestamp>, INTERVAL <step_int> <date_part>)
Returns an array of timestamp.
Supported date_part must be either DAY, HOUR, MINUTE, SECOND
The step_int parameter determines the increment used to generate timestamps.
Last updated