Date & Time

TIME_DIFF

BigQueryBigQuery

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

Tipe hasil: INT64Diperbarui: 13 Jun 2026

Syntax

SQL
TIME_DIFF(time_expression_a, time_expression_b, time_part)

Parameter

time_expression_aTIMEwajib

The end TIME value (minuend)

time_expression_bTIMEwajib

The start TIME value (subtrahend)

time_partTIME_PARTwajib

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

Contoh Penggunaan

Calculate Work Hours

SQL
1SELECT
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;

Calculate the number of hours worked.

Hasil
clock_inclock_outwork_hourswork_minutes
09:00:0017:30:008510

Meeting Duration

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

Calculate meeting duration in minutes.

Pertanyaan Umum tentang TIME_DIFF

Apa itu fungsi TIME_DIFF di BigQuery?
Calculates the difference between two TIME values in the specified unit. Di BigQuery, fungsi TIME_DIFF termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan TIME_DIFF di BigQuery?
Gunakan sintaks berikut: TIME_DIFF(time_expression_a, time_expression_b, time_part). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi TIME_DIFF?
Fungsi TIME_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 TIME_DIFF?
Fungsi ini memiliki 3 parameter wajib. Parameter yang digunakan: time_expression_a (TIME, wajib): The end TIME value (minuend); time_expression_b (TIME, wajib): The start TIME value (subtrahend); time_part (TIME_PART, wajib): Result unit: HOUR, MINUTE, SECOND, MILLISECOND, MICROSECOND.
Ngulik Langsung

Sudah paham TIME_DIFF? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →
Kembali ke BigQuery Functions