Date & Time

TIMESTAMP_TRUNC

Q: Apa saja parameter fungsi TIMESTAMP_TRUNC?

Fungsi ini memiliki 2 parameter wajib dan 1 parameter opsional. Parameter yang digunakan: timestamp_expression (TIMESTAMP, wajib): The TIMESTAMP to truncate; timestamp_part (TIMESTAMP_PART, wajib): Granularity: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, etc.; time_zone (STRING, opsional): Timezone for calculation (defaults to UTC).

BigQuery

Truncates a TIMESTAMP to the specified granularity. Supports timezone for accurate local-time results.

Tipe hasil: TIMESTAMPDiperbarui: 13 Jun 2026

Syntax

SQL

TIMESTAMP_TRUNC(timestamp_expression, timestamp_part [, time_zone])

Parameter

timestamp_expressionTIMESTAMPwajib

The TIMESTAMP to truncate

timestamp_partTIMESTAMP_PARTwajib

Granularity: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, etc.

time_zoneSTRINGopsional

Timezone for calculation (defaults to UTC)

Contoh Penggunaan

Basic Truncation

SQL

1 SELECT
2   ts,
3   TIMESTAMP_TRUNC(ts, DAY) as day_utc,
4   TIMESTAMP_TRUNC(ts, DAY, 'Asia/Jakarta') as day_jakarta
5 FROM UNNEST([TIMESTAMP '2024-01-15 20:00:00 UTC']) as ts;

Truncate a timestamp using different timezones.

Hasil

ts	day_utc	day_jakarta
2024-01-15 20:00:00 UTC	2024-01-15 00:00:00 UTC	2024-01-15 17:00:00 UTC

Daily Metrics

SQL

1 SELECT
2   TIMESTAMP_TRUNC(event_time, DAY, 'Asia/Jakarta') as day,
3   COUNT(DISTINCT user_id) as daily_active_users
4 FROM `project.dataset.events`
5 GROUP BY day
6 ORDER BY day;

Calculate daily active users using a local timezone.

Pertanyaan Umum tentang TIMESTAMP_TRUNC

Apa itu fungsi TIMESTAMP_TRUNC di BigQuery?

Truncates a TIMESTAMP to the specified granularity. Supports timezone for accurate local-time results. Di BigQuery, fungsi TIMESTAMP_TRUNC termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan TIMESTAMP_TRUNC di BigQuery?

Gunakan sintaks berikut: TIMESTAMP_TRUNC(timestamp_expression, timestamp_part [, time_zone]). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi TIMESTAMP_TRUNC?

Fungsi TIMESTAMP_TRUNC mengembalikan nilai bertipe TIMESTAMP. 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.

Fungsi Terkait

DATE_TRUNCTIME_TRUNCDATETIME_TRUNC

Ngulik Langsung

Sudah paham TIMESTAMP_TRUNC? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	ts,
3	TIMESTAMP_TRUNC(ts, DAY) as day_utc,
4	TIMESTAMP_TRUNC(ts, DAY, 'Asia/Jakarta') as day_jakarta
5	FROM UNNEST([TIMESTAMP '2024-01-15 20:00:00 UTC']) as ts;

1	SELECT
2	TIMESTAMP_TRUNC(event_time, DAY, 'Asia/Jakarta') as day,
3	COUNT(DISTINCT user_id) as daily_active_users
4	FROM `project.dataset.events`
5	GROUP BY day
6	ORDER BY day;