DECLARE @dt1 datetime, @dt2 datetime SET @dt1 = '2005/07/01 10:45:15' SET @dt2 = '2005/07/01 17:23:37' SELECT CONVERT(varchar(20), CAST(@dt2 - @dt1 AS datetime), 108)