Date & Time

MAKE_DATE

BigQuery

Membuat DATE dari komponen year, month, dan day.

Tipe hasil: DATEDiperbarui: 7 Jan 2026

Syntax

SQL

MAKE_DATE(year, month, day)

yearINT64wajib

Tahun (1-9999)

monthINT64wajib

Bulan (1-12)

dayINT64wajib

Hari (1-31, tergantung bulan)

SQL

1 SELECT
2   MAKE_DATE(2024, 6, 15) as created_date,
3   MAKE_DATE(year, 1, 1) as first_day_of_year
4 FROM (SELECT 2024 as year);

Membuat DATE dari komponen.

Hasil

created_date	first_day_of_year
2024-06-15	2024-01-01

1	SELECT
2	MAKE_DATE(2024, 6, 15) as created_date,
3	MAKE_DATE(year, 1, 1) as first_day_of_year
4	FROM (SELECT 2024 as year);