Date & Time

DATE_TRUNC

BigQuery

Truncates a DATE to the specified granularity (DAY, WEEK, MONTH, QUARTER, YEAR).

Tipe hasil: DATEDiperbarui: 13 Jun 2026

Syntax

SQL

DATE_TRUNC(date_expression, date_part)

Parameter

date_expressionDATEwajib

The DATE to truncate

date_partDATE_PARTwajib

Granularity: DAY, WEEK, MONTH, QUARTER, YEAR, etc.

Contoh Penggunaan

Basic Truncation

SQL

1 SELECT
2   date,
3   DATE_TRUNC(date, WEEK) as week_start,
4   DATE_TRUNC(date, MONTH) as month_start,
5   DATE_TRUNC(date, YEAR) as year_start
6 FROM UNNEST([DATE '2024-01-15']) as date;

Truncate a date to various granularities.

Hasil

date	week_start	month_start	year_start
2024-01-15	2024-01-14	2024-01-01	2024-01-01

Monthly Aggregation

SQL

1 SELECT
2   DATE_TRUNC(order_date, MONTH) as month,
3   COUNT(*) as order_count,
4   SUM(amount) as total_amount
5 FROM `project.dataset.orders`
6 GROUP BY month
7 ORDER BY month;

Aggregate sales by month using date truncation.

Week Starting Monday

SQL

1 SELECT
2   date,
3   DATE_TRUNC(date, WEEK(MONDAY)) as week_monday
4 FROM UNNEST([DATE '2024-01-15']) as date;

Truncate to the start of the week, with Monday as the first day.

Hasil

date	week_monday
2024-01-15	2024-01-15

Pertanyaan Umum tentang DATE_TRUNC

Apa itu fungsi DATE_TRUNC di BigQuery?

Truncates a DATE to the specified granularity (DAY, WEEK, MONTH, QUARTER, YEAR). Di BigQuery, fungsi DATE_TRUNC termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan DATE_TRUNC di BigQuery?

Gunakan sintaks berikut: DATE_TRUNC(date_expression, date_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi DATE_TRUNC?

Fungsi DATE_TRUNC mengembalikan nilai bertipe DATE. 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 DATE_TRUNC?

Fungsi ini memiliki 2 parameter wajib. Parameter yang digunakan: date_expression (DATE, wajib): The DATE to truncate; date_part (DATE_PART, wajib): Granularity: DAY, WEEK, MONTH, QUARTER, YEAR, etc..

Fungsi Terkait

TIMESTAMP_TRUNCTIME_TRUNCDATETIME_TRUNC

Ngulik Langsung

Sudah paham DATE_TRUNC? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	date,
3	DATE_TRUNC(date, WEEK) as week_start,
4	DATE_TRUNC(date, MONTH) as month_start,
5	DATE_TRUNC(date, YEAR) as year_start
6	FROM UNNEST([DATE '2024-01-15']) as date;

1	SELECT
2	DATE_TRUNC(order_date, MONTH) as month,
3	COUNT(*) as order_count,
4	SUM(amount) as total_amount
5	FROM `project.dataset.orders`
6	GROUP BY month
7	ORDER BY month;

1	SELECT
2	date,
3	DATE_TRUNC(date, WEEK(MONDAY)) as week_monday
4	FROM UNNEST([DATE '2024-01-15']) as date;