Date & Time

DATETIME_DIFF

Q: Apa saja parameter fungsi DATETIME_DIFF?

Fungsi ini memiliki 3 parameter wajib. Parameter yang digunakan: datetime_expression_a (DATETIME, wajib): The end DATETIME value (minuend); datetime_expression_b (DATETIME, wajib): The start DATETIME value (subtrahend); datetime_part (DATETIME_PART, wajib): Result unit: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, etc..

BigQuery

Calculates the difference between two DATETIME values in the specified unit.

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL

DATETIME_DIFF(datetime_expression_a, datetime_expression_b, datetime_part)

Parameter

datetime_expression_aDATETIMEwajib

The end DATETIME value (minuend)

datetime_expression_bDATETIMEwajib

The start DATETIME value (subtrahend)

datetime_partDATETIME_PARTwajib

Result unit: YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, etc.

Contoh Penggunaan

Calculate Duration

SQL

1 SELECT
2   start_datetime,
3   end_datetime,
4   DATETIME_DIFF(end_datetime, start_datetime, HOUR) as hours,
5   DATETIME_DIFF(end_datetime, start_datetime, MINUTE) as minutes
6 FROM `project.dataset.sessions`;

Calculate session duration in hours and minutes.

Time Since Event

SQL

1 SELECT
2   event_id,
3   event_datetime,
4   DATETIME_DIFF(CURRENT_DATETIME(), event_datetime, DAY) as days_ago
5 FROM `project.dataset.events`
6 ORDER BY days_ago;

Calculate how many days ago each event occurred.

Pertanyaan Umum tentang DATETIME_DIFF

Apa itu fungsi DATETIME_DIFF di BigQuery?

Calculates the difference between two DATETIME values in the specified unit. Di BigQuery, fungsi DATETIME_DIFF termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan DATETIME_DIFF di BigQuery?

Gunakan sintaks berikut: DATETIME_DIFF(datetime_expression_a, datetime_expression_b, datetime_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi DATETIME_DIFF?

Fungsi DATETIME_DIFF mengembalikan nilai bertipe INT64. 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.

Ngulik Langsung

Sudah paham DATETIME_DIFF? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	start_datetime,
3	end_datetime,
4	DATETIME_DIFF(end_datetime, start_datetime, HOUR) as hours,
5	DATETIME_DIFF(end_datetime, start_datetime, MINUTE) as minutes
6	FROM `project.dataset.sessions`;

1	SELECT
2	event_id,
3	event_datetime,
4	DATETIME_DIFF(CURRENT_DATETIME(), event_datetime, DAY) as days_ago
5	FROM `project.dataset.events`
6	ORDER BY days_ago;