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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment