[thelist] sql query for sum of timediff

Phil Turmel philip at turmel.org
Fri Jun 2 12:40:52 CDT 2006


Canfield, Joel wrote:
>>(Not tested...)
> 
> 
> works; see previous response to matt
> 
> thanks phil
> 
> joel

There is a slight difference... My suggestion doesn't blow up if a call 
crosses midnight.

Of course, if you want to count only the time of such calls that occur 
during the requested time period, you've more complicated boundary 
checking to do.

Phil



More information about the thelist mailing list