SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;

(No column name)

Microsoft SQL Server 2017 (RTM-CU12) (KB4464082) - 14.0.3045.24 (X64) 
	Oct 18 2018 23:11:05 
	Copyright (C) 2017 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)

create table t (d sql_variant);
insert into t (d) values
('2007-11-13 15:40:15.627'),
('2007-11-13 16:27:13.783'),
('2007-11-13 17:18:47.783'),
('2007-11-16 14:06:27.917'),
('2007-11-20 12:49:17.343'),
('2007-11-21 10:57:23.903') ;

6 rows affected

select * from t ;

d

2007-11-13 15:40:15.627

2007-11-13 16:27:13.783

2007-11-13 17:18:47.783

2007-11-16 14:06:27.917

2007-11-20 12:49:17.343

2007-11-21 10:57:23.903

select * from t where d between CONVERT(datetime, '11/16/2007') and DATEADD(day,1,CONVERT(datetime,  '11/21/2008')) ;

d

select * from t where d between '2007-11-16' and '2008-11-21' ;

d

2007-11-16 14:06:27.917

2007-11-20 12:49:17.343

2007-11-21 10:57:23.903

select * from t where convert(datetime, d) between '2007-11-16' and '2008-11-21' ;

d

2007-11-16 14:06:27.917

2007-11-20 12:49:17.343

2007-11-21 10:57:23.903