MYSQL：求该列的时间和

Question

time
1:00
2:00
1:23
1:12希望得到结果：5:35
请大神留名。

Answer 1

mysql> select * from t_shuai45;
+----------+
| time     |
+----------+
| 01:00:00 |
| 02:00:00 |
| 01:23:00 |
| 01:12:00 |
+----------+
4 rows in set (0.00 sec)mysql> select SEC_TO_TIME(sum(TIME_TO_SEC(`time`))) from t_shuai45;
+---------------------------------------+
| SEC_TO_TIME(sum(TIME_TO_SEC(`time`))) |
+---------------------------------------+
| 05:35:00                              |
+---------------------------------------+
1 row in set (0.00 sec)mysql>