Date & Time

MAKETIME

MySQL

Membuat TIME dari komponen jam, menit, dan detik. Return nilai TIME.

Tipe hasil: TIMEDiperbarui: 7 Jan 2026

Syntax

SQL

MAKETIME(hour, minute, second)

hourINTwajib

Jam (0-838)

minuteINTwajib

Menit (0-59)

secondINTwajib

Detik (0-59)

SQL

1 SELECT MAKETIME(14, 30, 0) AS time_val;

Membuat waktu 14:30:00.

Hasil

time_val: 14:30:00

SQL

1 SELECT MAKETIME(100, 30, 15) AS duration;

Durasi lebih dari 24 jam.

Hasil

duration: 100:30:15

SQL

1 SELECT MAKETIME(hour_val, minute_val, 0) AS scheduled_time
2 FROM schedules;

Konstruksi waktu dari komponen.

Hasil

(constructed times)

1	SELECT MAKETIME(hour_val, minute_val, 0) AS scheduled_time
2	FROM schedules;