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 2009




Return to the Artful Common Queries page