Monday, August 18, 2014

Convert seconds to hh:mm:ss

DECLARE @TimeinSecond INT
 SET @TimeinSecond =86399 -- Change the seconds
SELECT RIGHT('0' + CAST(@TimeinSecond / 3600 AS VARCHAR),2) + ':' +
RIGHT('0' + CAST((@TimeinSecond / 60) % 60 AS VARCHAR),2)  + ':' +
RIGHT('0' + CAST(@TimeinSecond % 60 AS VARCHAR),2)

No comments:

Post a Comment