MYSQL：求该列的时间和

[shuai45]

time
1:00
2:00
1:23
1:12

希望得到结果：5:35
请大神留名。

[ACMAIN_CHM]

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>

[shuai45]

引用 1 楼 ACMAIN_CHM 的回复:

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>

多谢。