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