MySQL Addtime() : Adding time to datetime

The ADDTIME() function adds a time interval to a time/datetime and then returns the time/datetime.

Syntax

ADDTIME(datetime, addtime)

Parameter	Description
datetime	Required. The time/datetime to be modified
addtime	Required. The time interval to add to datetime. Both positive and negative values are allowed

Example:

SELECT ADDTIME(“2021-06-03 09:34:21”, “2”);

Output:

2021-06-03 09:34:23

Add 2 hours, 10 minutes, 5 seconds, and 3 microseconds to a time and return the datetime:

SELECT ADDTIME(“2017-06-15 09:34:21.000001”, “2:10:5.000003”);

Add 5 days, 2 hours, 10 minutes, 5 seconds, and 3 microseconds to a time and return the datetime:

SELECT ADDTIME(“2017-06-15 09:34:21.000001”, “5 2:10:5.000003”);