title: Ignoring the time element of a datetime field
body: <p>I have a datetime field in my table. I want to delete records based on a date but I am not interested in the time element. How would I write the SQL for this ? I am using MS SQL 2008.</p>