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'
May 21, 2010
Converting seconds to Minutes and Seconds mm:ss
-------------- --------------
Subscribe to:
Posts (Atom)