Date & Time
BigQuery
TIME_DIFF
BigQueryCalculates the difference between two TIME values in the specified unit.
Tipe hasil:
INT64Diperbarui: 13 Jun 2026Syntax
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
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;
Calculate the number of hours worked.
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`;
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.
Ngulik Langsung
Latihan Langsung →Sudah paham TIME_DIFF? Latih langsung di browser
Latihan interaktif, langsung di browser.