Date & Time

ADDTIME

MySQL

Menambahkan waktu (expr2) ke datetime atau time expression (expr1).

Tipe hasil: TIME/DATETIME

Syntax

SQL

ADDTIME(expr1, expr2)

expr1TIME/DATETIMEwajib

Waktu atau datetime awal

expr2TIMEwajib

Waktu yang akan ditambahkan (format: 'HH:MM:SS')

SQL

1 SELECT ADDTIME('10:00:00', '02:30:00') AS result;

Tambah 2 jam 30 menit.

Hasil

result: 12:30:00

SQL

1 SELECT ADDTIME('2024-01-15 10:00:00', '05:30:00') AS result;

Tambah waktu ke datetime.

Hasil

result: 2024-01-15 15:30:00

SQL

1 SELECT task_name,
2        start_time,
3        ADDTIME(start_time, estimated_duration) AS est_completion
4 FROM tasks;

Menghitung estimasi selesai.

Hasil

(estimated completion times)

1	SELECT task_name,
2	start_time,
3	ADDTIME(start_time, estimated_duration) AS est_completion
4	FROM tasks;