[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