title: Check if datetime is in current date
body: <p>I am using SQLServer 2008. I have a table X with field Y that is a datetime format. In the WHERE statement of my query I only want to keep the rows where the date of field Y equals the current date.</p>
  
  <p>I have searched the internet but couldnt find an example that works for SQLServer/</p>
  
  <p>Thank you for your help!</p>