ADDTIME

声明

ADDTIME(expr1,expr2)

说明

expr1 是时间或日期时间表达式，而 expr2 是时间表达式。ADDTIME() 将 expr2 添加到 expr1 并返回结果。

示例

SELECT ADDTIME('2022-09-08 23:59:59.999999', '1 1:1:1.000002');
+---------------------------------------------------------+
| ADDTIME('2022-09-08 23:59:59.999999', '1 1:1:1.000002') |
+---------------------------------------------------------+
| 2022-09-10 01:01:01.000001                              |
+---------------------------------------------------------+
1 row in set (0.001 sec)

SELECT ADDTIME('01:10:01.999999', '02:01:10.999998');
+-----------------------------------------------+
| ADDTIME('01:10:01.999999', '02:01:10.999998') |
+-----------------------------------------------+
| 03:11:12.999997                               |
+-----------------------------------------------+
1 row in set (0.000 sec)