Date & Time

CURRENT_DATETIME

BigQuery

Mengembalikan datetime saat ini (tanggal dan waktu tanpa timezone) berdasarkan timezone yang ditentukan.

Tipe hasil: DATETIMEDiperbarui: 7 Jan 2026

Syntax

SQL

CURRENT_DATETIME([time_zone])

time_zoneSTRINGopsional

Timezone string

SQL

1 SELECT
2   CURRENT_DATETIME() as now,
3   CURRENT_DATETIME('Asia/Jakarta') as jakarta,
4   CURRENT_DATETIME('UTC') as utc;

Datetime saat ini di berbagai timezone.

Hasil

now	jakarta	utc
2024-01-15T14:30:00.123	2024-01-15T21:30:00.123	2024-01-15T14:30:00.123

SQL

1 SELECT
2   FORMAT_DATETIME('%Y-%m-%d %H:%M', CURRENT_DATETIME('Asia/Jakarta')) as formatted;

Format datetime untuk display.

Hasil

2024-01-15 21:30

1	SELECT
2	CURRENT_DATETIME() as now,
3	CURRENT_DATETIME('Asia/Jakarta') as jakarta,
4	CURRENT_DATETIME('UTC') as utc;

1	SELECT
2	FORMAT_DATETIME('%Y-%m-%d %H:%M', CURRENT_DATETIME('Asia/Jakarta')) as formatted;