Date & Time

CURRENT_TIME

BigQuery

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

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

CURRENT_TIME([time_zone])

Parameter

time_zoneSTRINGopsional

Timezone string

Contoh Penggunaan

Get Current Time

SQL

1 SELECT
2   CURRENT_TIME() as now,
3   CURRENT_TIME('Asia/Jakarta') as jakarta_time,
4   CURRENT_TIME('UTC') as utc_time;

Waktu saat ini di berbagai timezone.

Hasil

now	jakarta_time	utc_time
14:30:00	21:30:00	14:30:00

Business Hours Check

SQL

1 SELECT
2   CASE
3     WHEN CURRENT_TIME('Asia/Jakarta') BETWEEN '09:00:00' AND '17:00:00'
4     THEN 'Open'
5     ELSE 'Closed'
6   END as store_status;

Cek apakah dalam jam operasional.

Fungsi Terkait

CURRENT_DATECURRENT_TIMESTAMP

Kembali ke BigQuery Functions

1	SELECT
2	CURRENT_TIME() as now,
3	CURRENT_TIME('Asia/Jakarta') as jakarta_time,
4	CURRENT_TIME('UTC') as utc_time;

1	SELECT
2	CASE
3	WHEN CURRENT_TIME('Asia/Jakarta') BETWEEN '09:00:00' AND '17:00:00'
4	THEN 'Open'
5	ELSE 'Closed'
6	END as store_status;