title: Compare dates in T-SQL, ignoring the time part
body: <p>I'm using MS SQL 2005, and I want to check two dates for equality, but ignoring the time part.</p>
  
  <p>I know I can make use of <a href="http://msdn.microsoft.com/en-us/library/ms189794.aspx" rel="noreferrer">DATEDIFF</a>, but am concerned that it may be slow - this SP gets used in the DB a lot!</p>
  
  <p>Any suggestions?</p>
  
  <p><b>Edit:</b> David Andres' comment: <blockquote>'"comparison" includes much more than equality' </blockquote> made me realise that I didn't make my question clear enough - I am actually just checking for equality, that is all.</p>