Jump to content


This topic is now archived and is closed to further replies.


select sum(time) from table

Recommended Posts

I have problems summing up times using the following select:


$Query ="SELECT SUM(TimeField) from myTable";


I have tried to set to TimeField to be a TIME and a TIMESTAMP field.

What MySQL does it summarizes the time, but it counts to 100 on seconds and minutes.


1) 00:45:50

2) 00:20:21 => Output: 6571

I would like perform a select where I get to total time from all the records in HH:MM:SS format. Can anyone help please!

Share this post

Link to post
Share on other sites

Thanks a lot!


select SEC_TO_TIME(sum(TIME_TO_SEC(time_filed))) from table_name>; 

did not work but by adding AS Answer like


select SEC_TO_TIME(sum(TIME_TO_SEC(time_filed))) AS Answer from table_name>; 


I got it to work

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.