title: Group by date without time
body: <p>I was wondering whether there was a way to group dates that are 2014-01-26 05:39:29.000 and 2014-01-26 07:45:31.000 into one day when counting them. I currently have the following code that just groups them by their unique datetime.</p>
  
  <pre><code>    SELECT ETK_ExpirationDateTime, COUNT(*) as TotalRows
      FROM History_Action 
      WHERE [State] = 4
      GROUP BY ETK_ExpirationDateTime
      ORDER BY ETK_ExpirationDateTime 
  </code></pre>
  
  <p>Is there a cast or something I can do to make those 2 dates above appear as one row with a total sum?</p>