Sum time values

from the Artful Common Queries page

SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( time_col ))) AS total_time 
FROM tbl;
Summing values like '12:65:23' produces meaningless results.

Last updated 22 May 2024