MySQL Addtime() : Adding time to datetime

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(datetimeaddtime)

Parameter Values

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

Example

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”);

Example

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”);