DECLARE @polygon geography = geography::STGeomFromText('POLYGON((-5.595396 48.797749, 1.523745 48.797749, 1.523745 50.908162, -5.595396 50.908162, -5.595396 48.797749))', 4326);

SELECT * FROM [dbo].[test] WHERE Time > '2021-01-01T23:59:59.997' AND Time <= '2021-01-02T23:59:59.997';

SELECT * FROM dbo.test WHERE Time > '2021-01-01T23:59:59.997' AND Time <= '2021-01-02T23:59:59.997' 
AND @polygon.STContains(Location) = 1;