SELECT * FROM TABLE
where create_date between Dateadd(DAY, Datediff(DAY, 0, Getdate()) , 0)
and DATEADD(second, -1, Dateadd(DAY, Datediff(DAY, 0, Getdate() + 1) , 0)) ;
SELECT * FROM TABLE
where create_date between '11/26/2019 00:00:00' and '11/26/2019 23:59:59';