Date & Time

TIME_TRUNC

BigQuery

Truncates a TIME value to the specified granularity (MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR).

Tipe hasil: TIMEDiperbarui: 13 Jun 2026

Syntax

SQL

TIME_TRUNC(time_expression, time_part)

Parameter

time_expressionTIMEwajib

The TIME value to truncate

time_partTIME_PARTwajib

Granularity: 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;

Truncate a time value to various granularities.

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;

Analyze event traffic grouped by hour.

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.

Pertanyaan Umum tentang TIME_TRUNC

Apa itu fungsi TIME_TRUNC di BigQuery?

Truncates a TIME value to the specified granularity (MICROSECOND, MILLISECOND, SECOND, MINUTE, HOUR). Di BigQuery, fungsi TIME_TRUNC termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan TIME_TRUNC di BigQuery?

Gunakan sintaks berikut: TIME_TRUNC(time_expression, time_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi TIME_TRUNC?

Fungsi TIME_TRUNC mengembalikan nilai bertipe TIME. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Apa saja parameter fungsi TIME_TRUNC?

Fungsi ini memiliki 2 parameter wajib. Parameter yang digunakan: time_expression (TIME, wajib): The TIME value to truncate; time_part (TIME_PART, wajib): Granularity: HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND.

Fungsi Terkait

DATE_TRUNCTIMESTAMP_TRUNCDATETIME_TRUNC

Ngulik Langsung

Sudah paham TIME_TRUNC? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

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;