title: Compare DATETIME and DATE ignoring time portion
body: <p>I have two tables where column <code>[date]</code> is type of <code>DATETIME2(0)</code>.</p>
  
  <p>I have to compare two records only by theirs Date parts (day+month+year), discarding Time parts (hours+minutes+seconds).</p>
  
  <p>How can I do that?</p>