Declare @starttime datetime = '7/23/2020 3:30:02 PM' Declare @endtime datetime = '7/23/2020 3:30:07 PM'
select CONVERT(VARCHAR, @endtime - @starttime, 108)