Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
305
Views
0
Helpful
1
Replies

Convert Time

mymite060708
Level 1
Level 1

‎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

Labels:
0 Helpful
1 Reply 1

villarrealed
Level 1
Level 1

‎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

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents