[thelist] sql query for sum of timediff

[Phil Turmel]

Canfield, Joel wrote:
>>select firstname, lastname, sum(timediff(endtime,starttime))
>>from presence
>>where starttime between '2006-05-31 0:00:00' and '2006-05-31 23:59:59'
>>group by firstname, lastname
> 
> 
Sum needs to work on numbers...  Try this:

select firstname, lastname,
sec_to_time(sum(time_to_sec(timediff(endtime,starttime))))
from presence
where starttime between '2006-05-31 0:00:00' and '2006-05-31 23:59:59'
group by firstname, lastname


(Not tested...)

Phil