Suma Columnas Time

[leonardo_josue]

Hola neocalichin:

Puedes probar así;

Código MySQL:

mysql> SELECT * FROM horas;
+----------+
| hora     |
+----------+
| 08:02:00 |
| 15:30:02 |
| 20:30:02 |
+----------+
3 rows in set (0.00 sec)
 
mysql> SELECT
    ->   SEC_TO_TIME( SUM( TIME_TO_SEC( hora ) ) ) AS total_horas
    -> FROM horas;
+-------------+
| total_horas |
+-------------+
| 44:02:04    |
+-------------+
1 row in set (0.00 sec)
 

Saludos
Leo.