SQL时间差转换成几时几分几秒的格式
更新:HHH   时间:2023-1-7


DECLARE @t1 TIME, @t2 TIME
SET @t1 = '10:10:20'
SET @t2 = '12:10:30'
SELECT @t1, @t2, CONVERT(varchar, DATEADD(s, DATEDIFF(s,@t1,@t2), 0), 108)



返回开发技术教程...