Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Convert Time

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

1 REPLY

Re: Convert Time

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

111
Views
0
Helpful
1
Replies