mysql datetime 差值 diff 分钟，会截断秒数

本文主要是介绍mysql datetime 差值 diff 分钟，会截断秒数，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

返回是 后面的时间 减去 前面的时间 ！！！！ 

mysql> select TIMESTAMPDIFF(MINUTE, '2018-03-20 09:00:00', '2018-03-20 09:19:00');
+---------------------------------------------------------------------+
| TIMESTAMPDIFF(MINUTE, '2018-03-20 09:00:00', '2018-03-20 09:19:00') |
+---------------------------------------------------------------------+
|                                                                  19 |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)mysql> select TIMESTAMPDIFF(MINUTE, '2018-03-20 09:00:00', '2018-03-20 09:29:30');
+---------------------------------------------------------------------+
| TIMESTAMPDIFF(MINUTE, '2018-03-20 09:00:00', '2018-03-20 09:29:30') |
+---------------------------------------------------------------------+
|                            

这篇关于mysql datetime 差值 diff 分钟，会截断秒数的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---