Date & Time

DATETIME

BigQuery

Membuat nilai DATETIME dari komponen, menggabungkan DATE dan TIME, atau mengkonversi dari TIMESTAMP.

Tipe hasil: DATETIMEDiperbarui: 7 Jan 2026

Syntax

SQL

DATETIME(year, month, day, hour, minute, second) | DATETIME(date [, time]) | DATETIME(timestamp [, time_zone])

Parameter

yearINT64opsional

Tahun

monthINT64opsional

Bulan (1-12)

dayINT64opsional

Hari

hourINT64opsional

Jam (0-23)

minuteINT64opsional

Menit (0-59)

secondINT64opsional

Detik (0-59)

dateDATEopsional

Komponen tanggal

timeTIMEopsional

Komponen waktu (default 00:00:00)

timestampTIMESTAMPopsional

Timestamp untuk dikonversi

time_zoneSTRINGopsional

Timezone untuk konversi timestamp

Contoh Penggunaan

Create from Components

SQL

1 SELECT
2   DATETIME(2024, 1, 15, 14, 30, 0) as dt;

Buat DATETIME dari komponen lengkap.

Hasil

2024-01-15T14:30:00

Combine Date and Time

SQL

1 SELECT
2   DATETIME(DATE '2024-01-15', TIME '14:30:00') as combined,
3   DATETIME(DATE '2024-01-15') as date_only;

Gabungkan DATE dan TIME menjadi DATETIME.

Hasil

combined	date_only
2024-01-15T14:30:00	2024-01-15T00:00:00

Convert from Timestamp

SQL

1 SELECT
2   ts,
3   DATETIME(ts) as dt_utc,
4   DATETIME(ts, 'Asia/Jakarta') as dt_jakarta
5 FROM UNNEST([TIMESTAMP '2024-01-15 10:00:00 UTC']) as ts;

Konversi timestamp ke datetime dengan timezone.

Hasil

ts	dt_utc	dt_jakarta
2024-01-15 10:00:00 UTC	2024-01-15T10:00:00	2024-01-15T17:00:00

Kembali ke BigQuery Functions

1	SELECT
2	DATETIME(DATE '2024-01-15', TIME '14:30:00') as combined,
3	DATETIME(DATE '2024-01-15') as date_only;

1	SELECT
2	ts,
3	DATETIME(ts) as dt_utc,
4	DATETIME(ts, 'Asia/Jakarta') as dt_jakarta
5	FROM UNNEST([TIMESTAMP '2024-01-15 10:00:00 UTC']) as ts;