Date & Time

DATETIME_TRUNC

BigQuery

Memotong DATETIME ke granularitas yang ditentukan. Mendukung semua date parts dari MICROSECOND hingga YEAR.

Tipe hasil: DATETIMEDiperbarui: 7 Jan 2026

Syntax

SQL

DATETIME_TRUNC(datetime_expression, datetime_part)

Parameter

datetime_expressionDATETIMEwajib

DATETIME yang akan dipotong

datetime_partDATETIME_PARTwajib

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

Potong datetime ke berbagai granularitas.

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;

Agregasi penjualan per jam.

Fungsi Terkait

DATE_TRUNCTIMESTAMP_TRUNCTIME_TRUNC

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;