var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: got seconds but need minutes
I have a result that comes out in number of seconds, but need to see it converted to minutes and hours and seconds. Is there a convert function that would do this?
DECLARE @x int
SELECT @x = 3600 + 1800
SELECT @x/60/60 AS Hours,CONVERT(Int,(@x/60.00/60.00-@x/60/60)*60) AS Seconds
I'm rather fond of:
SELECT Convert(CHAR(8), DateAdd(second, 45296, '0:00'), 8)
I like it!