Date & Time

TIMESTAMP_DIFF

BigQueryBigQuery

Calculates the difference between two TIMESTAMP values in the specified unit. Most accurate for measuring absolute durations.

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL
TIMESTAMP_DIFF(timestamp_expression_a, timestamp_expression_b, timestamp_part)

Parameter

timestamp_expression_aTIMESTAMPwajib

The end TIMESTAMP value (minuend)

timestamp_expression_bTIMESTAMPwajib

The start TIMESTAMP value (subtrahend)

timestamp_partTIMESTAMP_PARTwajib

Result unit: DAY, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND

Contoh Penggunaan

Calculate Response Time

SQL
1SELECT
2  request_id,
3  request_time,
4  response_time,
5  TIMESTAMP_DIFF(response_time, request_time, MILLISECOND) as latency_ms
6FROM `project.dataset.api_logs`;

Calculate API latency in milliseconds.

Session Duration

SQL
1SELECT
2  session_id,
3  TIMESTAMP_DIFF(session_end, session_start, SECOND) as duration_seconds,
4  TIMESTAMP_DIFF(session_end, session_start, MINUTE) as duration_minutes
5FROM `project.dataset.sessions`;

Calculate session duration in seconds and minutes.

Average Time Between Events

SQL
1SELECT
2  user_id,
3  AVG(TIMESTAMP_DIFF(event_time, LAG(event_time) OVER (PARTITION BY user_id ORDER BY event_time), SECOND)) as avg_time_between_events
4FROM `project.dataset.events`
5GROUP BY user_id;

Calculate the average time between events per user.

Pertanyaan Umum tentang TIMESTAMP_DIFF

Apa itu fungsi TIMESTAMP_DIFF di BigQuery?
Calculates the difference between two TIMESTAMP values in the specified unit. Most accurate for measuring absolute durations. Di BigQuery, fungsi TIMESTAMP_DIFF termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan TIMESTAMP_DIFF di BigQuery?
Gunakan sintaks berikut: TIMESTAMP_DIFF(timestamp_expression_a, timestamp_expression_b, timestamp_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi TIMESTAMP_DIFF?
Fungsi TIMESTAMP_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.
Apa saja parameter fungsi TIMESTAMP_DIFF?
Fungsi ini memiliki 3 parameter wajib. Parameter yang digunakan: timestamp_expression_a (TIMESTAMP, wajib): The end TIMESTAMP value (minuend); timestamp_expression_b (TIMESTAMP, wajib): The start TIMESTAMP value (subtrahend); timestamp_part (TIMESTAMP_PART, wajib): Result unit: DAY, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND.
Ngulik Langsung

Sudah paham TIMESTAMP_DIFF? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →
Kembali ke BigQuery Functions