SUBTIME() 將返回expr1 ,expr2表示為相同的格式expr1值。expr1是一個(gè)時(shí)間或日期時(shí)間表達(dá)式,expr2是一個(gè)時(shí)間。
mysql> SELECT SUBTIME('1997-12-31 23:59:59.999999',
-> '1 1:1:1.000002');
+---------------------------------------------------------+
| SUBTIME('1997-12-31 23:59:59.999999'... |
+---------------------------------------------------------+
| 1997-12-30 22:58:58.999997 |
+---------------------------------------------------------+
1 row in set (0.00 sec)