Date & Time

TIMESTAMP_DIFF

BigQuery

Menghitung selisih antara dua TIMESTAMP dalam unit yang ditentukan. Paling akurat untuk durasi absolut.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

TIMESTAMP_DIFF(timestamp_expression_a, timestamp_expression_b, timestamp_part)

Parameter

timestamp_expression_aTIMESTAMPwajib

TIMESTAMP akhir (minuend)

timestamp_expression_bTIMESTAMPwajib

TIMESTAMP awal (subtrahend)

timestamp_partTIMESTAMP_PARTwajib

Unit hasil: DAY, HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND

Contoh Penggunaan

Calculate Response Time

SQL

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

Hitung latency API dalam milliseconds.

Session Duration

SQL

1 SELECT
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
5 FROM `project.dataset.sessions`;

Hitung durasi session.

Average Time Between Events

SQL

1 SELECT
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
4 FROM `project.dataset.events`
5 GROUP BY user_id;

Rata-rata waktu antar event per user.

Fungsi Terkait

TIMESTAMP_ADDTIMESTAMP_SUB

Kembali ke BigQuery Functions

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

1	SELECT
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
5	FROM `project.dataset.sessions`;

1	SELECT
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
4	FROM `project.dataset.events`
5	GROUP BY user_id;