May 21, 2010

Converting seconds to Minutes and Seconds mm:ss

-------------- --------------

DECLARE @secs INT
SET @secs = 94

SELECT 
CASE 
    WHEN LEN(CAST(CAST(@secs AS real)/60 AS int)) = 1 
    THEN '0' 
    ELSE '' 
END 
+ CAST(CAST(CAST(@secs AS real)/60 AS int) AS nvarchar(2)) 
+ ':' +
CASE 
WHEN LEN(@secs - (CAST(CAST(@secs AS real)/60 AS int)*60)) = 1 
    THEN '0' 
    ELSE '' 
END 
+ CAST(@secs - (CAST(CAST(@secs AS real)/60 AS int)*60) AS nvarchar(2)) 
AS MinutesWithSeconds

--Result: '01:34'
Bookmark and Share

No comments:

Post a Comment