Convert Time

Unanswered Question
Mar 24th, 2009
User Badges:

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
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
villarrealed Tue, 03/24/2009 - 07:47
User Badges:
  • Bronze, 100 points or more

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