Array

GENERATE_DATE_ARRAY

BigQuery

Membuat array berisi sequence of dates.

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

Syntax

SQL

GENERATE_DATE_ARRAY(start_date, end_date [, interval])

Parameter

start_dateDATEwajib

Tanggal awal

end_dateDATEwajib

Tanggal akhir (inclusive)

intervalINTERVALopsional

Interval antar tanggal (default: 1 DAY)

Contoh Penggunaan

Generate Date Range

SQL

1 SELECT
2   GENERATE_DATE_ARRAY('2024-01-01', '2024-01-05') as daily,
3   GENERATE_DATE_ARRAY('2024-01-01', '2024-03-01', INTERVAL 1 MONTH) as monthly;

Membuat sequence tanggal.

Hasil

daily	monthly
[2024-01-01...2024-01-05]	[2024-01-01,2024-02-01,2024-03-01]

Kembali ke BigQuery Functions

1	SELECT
2	GENERATE_DATE_ARRAY('2024-01-01', '2024-01-05') as daily,
3	GENERATE_DATE_ARRAY('2024-01-01', '2024-03-01', INTERVAL 1 MONTH) as monthly;