Oldest Contact / convOldestContact

Googi1974 · ‎08-11-2009

Hi Everyone

This may be considered out of scope for this forum, but I wondered if anyone might know:

In the realtime CSQsSummary Table (IPCC Database) how they've done the conversion to get from millisecs (oldest contact) to the HH:MM:SS format (convOldest Contact). I have a need to perform that same conversion in my Inova Wallboard software, as I cannot compare fields with string values. I'm grateful for any input.

Thanks,

Kelly

paiged · ‎08-17-2009

--I think UCCX does it in the Crystal Templates.

--This is a SQL statement that will convert Seconds to HH:MM:SS string

--Declare variables

DECLARE

@sHHMMSS VARCHAR(15),

@nSeconds Int

--Set the starting value (this could also be retrieved from a select statement)

SELECT @nSeconds = 87200

SELECT @sHHMMSS =

RIGHT('00' + CONVERT(VARCHAR, FLOOR(@nSeconds/3600)), 2) + ':' +

RIGHT('00' + CONVERT(VARCHAR, FLOOR((@nSeconds % 3600)/60)), 2) + ':' +

RIGHT('00' + CONVERT(VARCHAR, FLOOR((@nSeconds % 60))), 2)

--Returns 24:13:20

PRINT @sHHMMSS

Googi1974 · ‎08-17-2009

Thank you for your help Paige!