[thelist] sql query for sum of timediff

[Canfield, Joel]

> what do you get with this:
> 
> select firstname, lastname, timediff(endtime,starttime)
> from presence
> where starttime between '2006-05-31 0:00:00' and '2006-05-31 23:59:59'

list of names with time-formatted durations, as

    bob   user    0:03:16
    jill  usette  0:11:32

etc. which is what I would expect.

I could certain do this, and mungy kludgy sum it in VBScript in the
page, but that's no fun.