Date & Time

TIME_DIFF

BigQuery

Menghitung selisih antara dua TIME dalam unit yang ditentukan.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

TIME_DIFF(time_expression_a, time_expression_b, time_part)

Parameter

time_expression_aTIMEwajib

TIME akhir (minuend)

time_expression_bTIMEwajib

TIME awal (subtrahend)

time_partTIME_PARTwajib

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

Contoh Penggunaan

Calculate Work Hours

SQL

1 SELECT
2   TIME '09:00:00' as clock_in,
3   TIME '17:30:00' as clock_out,
4   TIME_DIFF(TIME '17:30:00', TIME '09:00:00', HOUR) as work_hours,
5   TIME_DIFF(TIME '17:30:00', TIME '09:00:00', MINUTE) as work_minutes;

Hitung jam kerja.

Hasil

clock_in	clock_out	work_hours	work_minutes
09:00:00	17:30:00	8	510

Meeting Duration

SQL

1 SELECT
2   meeting_id,
3   start_time,
4   end_time,
5   TIME_DIFF(end_time, start_time, MINUTE) as duration_mins
6 FROM `project.dataset.meetings`;

Hitung durasi meeting dalam menit.

Kembali ke BigQuery Functions

1	SELECT
2	TIME '09:00:00' as clock_in,
3	TIME '17:30:00' as clock_out,
4	TIME_DIFF(TIME '17:30:00', TIME '09:00:00', HOUR) as work_hours,
5	TIME_DIFF(TIME '17:30:00', TIME '09:00:00', MINUTE) as work_minutes;

1	SELECT
2	meeting_id,
3	start_time,
4	end_time,
5	TIME_DIFF(end_time, start_time, MINUTE) as duration_mins
6	FROM `project.dataset.meetings`;