Date & Time

TIME

BigQuery

Membuat nilai TIME dari komponen atau mengekstrak TIME dari timestamp/datetime.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIME(hour, minute, second) | TIME(timestamp [, time_zone]) | TIME(datetime)

Parameter

hourINT64opsional

Jam (0-23)

minuteINT64opsional

Menit (0-59)

secondINT64opsional

Detik (0-59)

timestampTIMESTAMPopsional

Timestamp untuk diekstrak

datetimeDATETIMEopsional

Datetime untuk diekstrak

time_zoneSTRINGopsional

Timezone untuk konversi

Contoh Penggunaan

Create Time from Components

SQL

1 SELECT
2   TIME(14, 30, 0) as afternoon,
3   TIME(9, 0, 0) as morning,
4   TIME(23, 59, 59) as late_night;

Buat TIME dari hour, minute, second.

Hasil

afternoon	morning	late_night
14:30:00	09:00:00	23:59:59

Extract from Timestamp

SQL

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

Ekstrak TIME dari timestamp dengan timezone.

Hasil

ts	jakarta_time
2024-01-15 10:30:00 UTC	17:30:00

Business Hours Analysis

SQL

1 SELECT
2   order_id,
3   TIME(order_timestamp, 'Asia/Jakarta') as order_time,
4   CASE
5     WHEN TIME(order_timestamp, 'Asia/Jakarta') < TIME(9, 0, 0) THEN 'Before Hours'
6     WHEN TIME(order_timestamp, 'Asia/Jakarta') < TIME(17, 0, 0) THEN 'Business Hours'
7     ELSE 'After Hours'
8   END as time_category
9 FROM `project.dataset.orders`;

Kategorikan order berdasarkan jam.

Kembali ke BigQuery Functions

1	SELECT
2	TIME(14, 30, 0) as afternoon,
3	TIME(9, 0, 0) as morning,
4	TIME(23, 59, 59) as late_night;

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

1	SELECT
2	order_id,
3	TIME(order_timestamp, 'Asia/Jakarta') as order_time,
4	CASE
5	WHEN TIME(order_timestamp, 'Asia/Jakarta') < TIME(9, 0, 0) THEN 'Before Hours'
6	WHEN TIME(order_timestamp, 'Asia/Jakarta') < TIME(17, 0, 0) THEN 'Business Hours'
7	ELSE 'After Hours'
8	END as time_category
9	FROM `project.dataset.orders`;