Date & Time

TIME_TO_SEC

MySQL

Mengkonversi TIME ke jumlah detik. Kebalikan dari SEC_TO_TIME().

Tipe hasil: INTDiperbarui: 7 Jan 2026

Syntax

SQL

TIME_TO_SEC(time)

timeTIMEwajib

Nilai waktu yang akan dikonversi

SQL

1 SELECT TIME_TO_SEC('01:30:00') AS seconds;

1 jam 30 menit = 5400 detik.

Hasil

seconds: 5400

SQL

1 SELECT SUM(TIME_TO_SEC(duration)) AS total_seconds,
2        SEC_TO_TIME(SUM(TIME_TO_SEC(duration))) AS total_time
3 FROM work_logs;

Sum durasi dan konversi kembali.

Hasil

total_time: (sum of durations)

SQL

1 SELECT *
2 FROM tasks
3 WHERE TIME_TO_SEC(duration) > 3600;

Filter task lebih dari 1 jam.

Hasil

(tasks > 1 hour)

1	SELECT SUM(TIME_TO_SEC(duration)) AS total_seconds,
2	SEC_TO_TIME(SUM(TIME_TO_SEC(duration))) AS total_time
3	FROM work_logs;