generate_series (Integers)
Generate a series of integer values.
SELECT * FROM TABLE(
generate_series(
<series_start>,
<series_end>
[, <increment>]
)
heavysql> select * from table(generate_series(2, 10, 2));
series
2
4
6
8
10
5 rows returned.
heavysql> select * from table(generate_series(8, -4, -3));
series
8
5
2
-1
-4
5 rows returned.
generate_series (Timestamps)
SELECT * FROM TABLE(
generate_series(
<series_start>,
<series_end>,
<series_step>
)
)
SELECT
generate_series AS ts
FROM
TABLE(
generate_series(
TIMESTAMP(0) '2021-01-01 00:00:00',
TIMESTAMP(0) '2021-09-04 00:00:00',
INTERVAL '1' MONTH
)
)
ORDER BY ts;
ts
2021-01-01 00:00:00.000000000
2021-02-01 00:00:00.000000000
2021-03-01 00:00:00.000000000
2021-04-01 00:00:00.000000000
2021-05-01 00:00:00.000000000
2021-06-01 00:00:00.000000000
2021-07-01 00:00:00.000000000
2021-08-01 00:00:00.000000000
2021-09-01 00:00:00.000000000