Date & Time

TIME_TRUNC

BigQuery

Memotong TIME ke granularitas yang ditentukan (MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR).

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIME_TRUNC(time_expression, time_part)

Parameter

time_expressionTIMEwajib

TIME yang akan dipotong

time_partTIME_PARTwajib

Granularitas: HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND

Contoh Penggunaan

Basic Truncation

SQL

1 SELECT
2   time,
3   TIME_TRUNC(time, HOUR) as hour,
4   TIME_TRUNC(time, MINUTE) as minute
5 FROM UNNEST([TIME '14:35:42.123456']) as time;

Potong waktu ke berbagai granularitas.

Hasil

time	hour	minute
14:35:42.123456	14:00:00	14:35:00

Hourly Traffic Analysis

SQL

1 SELECT
2   TIME_TRUNC(TIME(event_timestamp, 'Asia/Jakarta'), HOUR) as hour,
3   COUNT(*) as events
4 FROM `project.dataset.events`
5 GROUP BY hour
6 ORDER BY hour;

Analisis traffic per jam.

Round to Nearest 15 Minutes

SQL

1 -- Truncate to 15-minute intervals
2 SELECT
3   original_time,
4   TIME_TRUNC(
5     TIME_ADD(original_time, INTERVAL 7 MINUTE),
6     HOUR
7   ) as rounded_15min
8 FROM UNNEST([TIME '14:08:00', TIME '14:22:00', TIME '14:38:00']) as original_time;

Approximate 15-minute rounding.

Fungsi Terkait

DATE_TRUNCTIMESTAMP_TRUNCDATETIME_TRUNC

Kembali ke BigQuery Functions

1	SELECT
2	time,
3	TIME_TRUNC(time, HOUR) as hour,
4	TIME_TRUNC(time, MINUTE) as minute
5	FROM UNNEST([TIME '14:35:42.123456']) as time;

1	SELECT
2	TIME_TRUNC(TIME(event_timestamp, 'Asia/Jakarta'), HOUR) as hour,
3	COUNT(*) as events
4	FROM `project.dataset.events`
5	GROUP BY hour
6	ORDER BY hour;

1	-- Truncate to 15-minute intervals
2	SELECT
3	original_time,
4	TIME_TRUNC(
5	TIME_ADD(original_time, INTERVAL 7 MINUTE),
6	HOUR
7	) as rounded_15min
8	FROM UNNEST([TIME '14:08:00', TIME '14:22:00', TIME '14:38:00']) as original_time;