Blog

In this guide, we will explain how to use the MySQL ADDTIME function with syntax and examples.

Description

The MySQL ADDTIME function returns a time/datetime value after which a certain time interval has been added.

Syntax

The syntax for the ADDTIME function is:

ADDTIME( start_value, time )

Parameters or Arguments

start_value

The time or datetime value to which the time interval should be added.

time

The value of the time interval that you wish to add. It can be a positive or negative value.

Note

• Using the ADDTIME function with a negative time value as a parameter is equivalent to using the SUBTIME function.
• See also the DATE_ADD, DATE_SUB, ADDDATE, and SUBDATE functions.

Applies To

The ADDTIME function can be used in the following versions :

• MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1.1

Example

Let’s look at some ADDTIME function examples and explore how to use the ADDTIME function.

For example:

mysql> SELECT ADDTIME('2014-02-13 08:44:21.000001', '2.000001');
Result: '2014-02-13 08:44:23.000002'

mysql> SELECT ADDTIME('2014-02-13 08:44:21.000001', '3:2.000001');
Result: '2014-02-13 11:46:21.000002'

mysql> SELECT ADDTIME('2014-02-13 08:44:21.000001', '4:3:2.000001');
Result: '2014-02-13 12:47:23.000002'

mysql> SELECT ADDTIME('2014-02-13 08:44:21.000001', '5 4:3:2.000001');
Result: '2014-02-18 12:47:23.000002'

mysql> SELECT ADDTIME('01:15:23.999998', '0.000001');
Result: '01:15:23.999999'

mysql> SELECT ADDTIME('01:15:23.999998', '5.000001');
Result: '01:15:28.999999'

mysql> SELECT ADDTIME('01:15:23.000001', '8:12:15.003441');
Result: '09:27:38.003442'

mysql> SELECT ADDTIME('01:15:23.000001', '-8:12:15.003441');
Result: '-06:56:52.003440'

Next Topic : Click Here