[thelist] sql query for sum of timediff

Canfield, Joel JCanfield at PacAdvantage.org
Fri Jun 2 13:20:32 CDT 2006


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

ah; excellent point. I'll investigate it from an educational
perspective, but we are not now, nor will we ever be, a 24-hour shop.
Call center hours are 7a - 6p, which is why I blatantly ignored midnight
in the first place.

thanks for the pointer, though.

joel



More information about the thelist mailing list