如何在Mysql中做time_to_minute？

Question

如何腾出时间到time_to_minute单位？(与time_to_sec相同)

mysql> select time_to_min('00:00:1');
mysql> select time_to_minute('00:00:1');

Answer 1

看起来很简单：

SELECT TIME_TO_SEC('00:00:1') / 60

Answer 2

mysql> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
-> 128885

来源：http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_timestampdiff