Convert Time

Unanswered Question
Mar 24th, 2009

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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
villarrealed Tue, 03/24/2009 - 07:47

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

Actions

This Discussion