Date & Time

TIMEDIFF

MySQL

Menghitung selisih antara dua waktu. Return TIME yang merepresentasikan perbedaan.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

TIMEDIFF(time1, time2)

time1TIME | DATETIMEwajib

Waktu pertama

time2TIME | DATETIMEwajib

Waktu kedua (dikurangi dari time1)

SQL

1 SELECT TIMEDIFF('14:30:00', '12:00:00') AS diff;

Selisih 2.5 jam.

Hasil

diff: 02:30:00

SQL

1 SELECT TIMEDIFF('10:00:00', '14:00:00') AS diff;

Waktu pertama lebih kecil.

Hasil

diff: -04:00:00

SQL

1 SELECT employee_id,
2        TIMEDIFF(clock_out, clock_in) AS worked
3 FROM attendance;

Menghitung jam kerja.

Hasil

(work durations)

1	SELECT employee_id,
2	TIMEDIFF(clock_out, clock_in) AS worked
3	FROM attendance;