[thelist] sql query for sum of timediff
Canfield, Joel
JCanfield at PacAdvantage.org
Fri Jun 2 08:20:06 CDT 2006
> 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.
More information about the thelist
mailing list