By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Declare @t table ( StartDate datetime , ENDDate datetime)
Insert into @t values ('2020-02-05 15:00:00.000','2020-02-05 15:30:00.000')
Insert into @t values ('2020-02-05 15:10:00.000','2020-02-05 15:20:00.000')
--Declare @time datetime ='2020-02-05 15:11:00.000'
Declare @time datetime ='2020-02-05 15:31:00.000'
select TOP 1 *
from @t
where StartDate <= @time
ORDER BY ABS(datediff(mi,ENDDate,@time))
| StartDate | ENDDate |
|---|---|
| 2020-02-05 15:00:00.000 | 2020-02-05 15:30:00.000 |