Array

GENERATE_TIMESTAMP_ARRAY

BigQuery

Membuat array berisi sequence of timestamps.

Tipe hasil: ARRAY<TIMESTAMP>Diperbarui: 7 Jan 2026

Syntax

SQL

GENERATE_TIMESTAMP_ARRAY(start_timestamp, end_timestamp, interval)

start_timestampTIMESTAMPwajib

Timestamp awal

end_timestampTIMESTAMPwajib

Timestamp akhir (inclusive)

intervalINTERVALwajib

Interval antar timestamp

SQL

1 SELECT GENERATE_TIMESTAMP_ARRAY(
2   TIMESTAMP '2024-01-01 00:00:00',
3   TIMESTAMP '2024-01-01 06:00:00',
4   INTERVAL 1 HOUR
5 ) as hourly;

Membuat sequence timestamp per jam.

Hasil

hourly
[2024-01-01 00:00:00,...,2024-01-01 06:00:00]

1	SELECT GENERATE_TIMESTAMP_ARRAY(
2	TIMESTAMP '2024-01-01 00:00:00',
3	TIMESTAMP '2024-01-01 06:00:00',
4	INTERVAL 1 HOUR
5	) as hourly;