I am some what new to SQL and am trying to query a table that has a date_time field in it and filter by that date_time field. The field shows the date and then the time that the line was written to the database.. i.e. '2001-10-31 15:35:24.000'.
My question is how do I get all data that happened on a specific day (like 10-31-2011) regardless of what the time is?
Thank you in advance for any help with this.