Date & Time

DATETIME_TRUNC

Q: Apa saja parameter fungsi DATETIME_TRUNC?

Fungsi ini memiliki 2 parameter wajib. Parameter yang digunakan: datetime_expression (DATETIME, wajib): The DATETIME value to truncate; datetime_part (DATETIME_PART, wajib): Granularity: YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, etc..

BigQuery

Truncates a DATETIME value to the specified granularity. Supports all date parts from MICROSECOND through YEAR.

Tipe hasil: DATETIMEDiperbarui: 13 Jun 2026

Syntax

SQL

DATETIME_TRUNC(datetime_expression, datetime_part)

Parameter

datetime_expressionDATETIMEwajib

The DATETIME value to truncate

datetime_partDATETIME_PARTwajib

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

Contoh Penggunaan

Basic Truncation

SQL

1 SELECT
2   dt,
3   DATETIME_TRUNC(dt, HOUR) as hour,
4   DATETIME_TRUNC(dt, DAY) as day,
5   DATETIME_TRUNC(dt, MONTH) as month
6 FROM UNNEST([DATETIME '2024-01-15 14:35:42']) as dt;

Truncate a datetime value to various granularities.

Hasil

dt	hour	day	month
2024-01-15T14:35:42	2024-01-15T14:00:00	2024-01-15T00:00:00	2024-01-01T00:00:00

Hourly Aggregation

SQL

1 SELECT
2   DATETIME_TRUNC(event_datetime, HOUR) as hour,
3   COUNT(*) as events,
4   SUM(revenue) as total_revenue
5 FROM `project.dataset.sales`
6 GROUP BY hour
7 ORDER BY hour;

Aggregate sales revenue by hour.

Pertanyaan Umum tentang DATETIME_TRUNC

Apa itu fungsi DATETIME_TRUNC di BigQuery?

Truncates a DATETIME value to the specified granularity. Supports all date parts from MICROSECOND through YEAR. Di BigQuery, fungsi DATETIME_TRUNC termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan DATETIME_TRUNC di BigQuery?

Gunakan sintaks berikut: DATETIME_TRUNC(datetime_expression, datetime_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi DATETIME_TRUNC?

Fungsi DATETIME_TRUNC mengembalikan nilai bertipe DATETIME. 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_TRUNCTIMESTAMP_TRUNCTIME_TRUNC

Ngulik Langsung

Sudah paham DATETIME_TRUNC? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	dt,
3	DATETIME_TRUNC(dt, HOUR) as hour,
4	DATETIME_TRUNC(dt, DAY) as day,
5	DATETIME_TRUNC(dt, MONTH) as month
6	FROM UNNEST([DATETIME '2024-01-15 14:35:42']) as dt;

1	SELECT
2	DATETIME_TRUNC(event_datetime, HOUR) as hour,
3	COUNT(*) as events,
4	SUM(revenue) as total_revenue
5	FROM `project.dataset.sales`
6	GROUP BY hour
7	ORDER BY hour;