03-24-2009 03:34 AM - edited 03-14-2019 03:50 AM
in the RTCSQsSummary tables values like Average wait time, Average Talk time etc are stores initially has integers. Does any one one how cisco covert these number in the the format 0:00:00 that is listed as ConVAvergaeWaittime or ConvAvgTalkTime
03-24-2009 07:47 AM
I've used this SQL conversion previously:
select FormattedTime =
Case When TimeValInSec/3600<10 then '0' else '' End
+ RTRIM(TimeValInSec/3600)
+ ':' + RIGHT('0'+RTRIM((TimeValInSec%3600)/60),2)
+ ':' + RIGHT('0'+RTRIM((TimeValInSec%3600)%60),2
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide
Log in to Community