ADDTIME('01:00:00.999999', '02:00:00.999998'); : ADDTIME « Date Time Functions « MySQL Tutorial






mysql>
mysql>
mysql>
mysql> SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');
+-----------------------------------------------+
| ADDTIME('01:00:00.999999', '02:00:00.999998') |
+-----------------------------------------------+
| 03:00:01.999997                               |
+-----------------------------------------------+
1 row in set (0.00 sec)

mysql>








14.3.ADDTIME
14.3.1.ADDTIME(expr1,expr2)
14.3.2.ADDTIME('01:00:00.999999', '02:00:00.999998');