Wednesday, March 21, 2012

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?
Thanks,
DanDECLARE @.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)-PatP|||I like it!

Simple, Elegant...sql

No comments:

Post a Comment