Comparing SQL dates without the time part 13 November 2005 (0) SELECT CAST(FLOOR(CAST( AS float))AS datetime)e.g. to get all rows where an product as been ordered today:SELECT *FROM Orders AS aWHERECAST(FLOOR(CAST( a.OrderDateTime AS float)) AS datetime) = CAST(FLOOR(CAST( GETDATE() AS float)) AS datetime) SHARE: