ADDTIME() FUNCTION The MySQL ADDTIME function gets a time value after adding a certain time interval. The various versions of MySQL support the ADDTIME function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0 and MySQL 4.1.1.
Syntax:
ADDTIME( start_value, time )
Parameters: start_value: It is used to specify the time to which the interval should be added. time: It is used to specify the time interval to be added.
Example 1:
mysql> SELECT ADDTIME ('2019-07-05 15:30:20.000003', '1.000005');
Output:
'2019-07-05 15:30:21.000008'
Explanation:
The desired time interval has been added to the start_value of the time.
Example 2:
mysql> SELECT ADDTIME ('15:30:20.000003', '5:6:7.000005');
Output:
'20:36:27. 000008'
Explanation:
The desired time interval has been added to the start_value of the time.
