WHERE DateID=FLOOR(CONVERT(FLOAT,GETDATE()))
SELECT CAST(FLOOR(CAST( getdate() AS float)) AS datetime)
http://www.stillnetstudios.com/comparing-dates-without-times-in-sql-server/