Loading lesson path
Concept visual
Start at both ends
Add 2 seconds to a time and return the datetime:
SELECT ADDTIME("2017-06-15
09:34:21", "2");Formula
The ADDTIME() function adds a time interval to a time/datetime and then returns the time/datetime.datetime, addtime )
Formula
Required. The time/datetime to be modified addtimeRequired. The time interval to add to datetime. Both positive and negative values are allowed
From MySQL 4.0
Add 5 seconds and 3 microseconds to a time and return the datetime:
SELECT ADDTIME("2017-06-15
09:34:21.000001", "5.000003");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");Add 2 hours, 10 minutes, 5 seconds, and 3 microseconds to a time and return the time: SELECT ADDTIME("09:34:21.000001", "2:10:5.000003");
❮ MySQL Functions