calculate sum time with mysql

Posted by kawtousse on Stack Overflow See other posts from Stack Overflow or by kawtousse
Published on 2010-06-16T15:51:25Z Indexed on 2010/06/16 15:52 UTC
Read the original article Hit count: 93

Filed under:

hi every one,

RDBMS: mysql

colonne names: Timefrom,timeuntill, timespent as the following

type of the colonnes:Time.

timefrom timeuntill timespent

10:00:00 12:00:00 02:00:00

08:00:00 09:00:00 01:00:00

how could i get the sum of the timespent. like this example it would be 03:00:00. when doing select sum(timespent) from mytable it display: 030000.

please help. thanks.

© Stack Overflow or respective owner

Related posts about sql