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
sql
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