Do not miss your data: the pitfalls of DATE and TIME in T-SQL. - Home

Do not miss your data: the pitfalls of DATE and TIME in T-SQL. - Home: "SELECT OrderID, OrderDate,ProductID
FROM Tmp_Orders
WHERE (CAST(FLOOR(CAST( OrderDate AS FLOAT )) AS DATETIME) BETWEEN '16-Jun-2008' AND '25-Jun-2008')
ORDER BY OrderDate;"