34,591
社区成员
发帖
与我相关
我的任务
分享
DECLARE @i INT
SET @i = 186400
SELECT CAST(@i / 3600 AS VARCHAR) + ':'
+ CASE WHEN LEN(@i % 3600 / 60) = 1
THEN '0' + CAST(@i % 3600 / 60 AS VARCHAR)
ELSE CAST(@i % 60 / 60 AS VARCHAR)
END + ':' + CASE WHEN LEN(@i % 60) = 1
THEN '0' + CAST(@i % 60 AS VARCHAR)
ELSE CAST(@i % 60 AS VARCHAR)
END
SELECT CONVERT(VARCHAR(8),DATEADD(ss,86399,'1900-01-01 00:00:00'),108)