SELECT RIGHT(‘00’+CONVERT(VARCHAR(10),Seconds/3600),2) +’:’ + RIGHT(‘00’+CONVERT(VARCHAR(2),(Seconds%3600)/60),2) +’:’ + RIGHT(‘00’+CONVERT(VARCHAR(2),Seconds%60),2) AS [HH:MM:SS] FROM table1
结果:
T-SQL格式秒为HH:MM:SS时间
SELECT RIGHT(‘00’+CONVERT(VARCHAR(10),Seconds/3600),2) +’:’ + RIGHT(‘00’+CONVERT(VARCHAR(2),(Seconds%3600)/60),2) +’:’ + RIGHT(‘00’+CONVERT(VARCHAR(2),Seconds%60),2) AS [HH:MM:SS] FROM table1
结果: