Datediff as time

CONVERT(varchar(12), DATEADD(ms, DATEDIFF(ms, @dt1, @dt2), 0), 114).

Updated: 2026 Aug 19