title: SQL Server Server query - Count distinct DateTime field
body: <p>Supposing we have the following records in an SQL Server table.</p>
  
  <pre><code>Date
  19/5/2009 12:00:00 pm
  19/5/2009 12:15:22 pm
  20/5/2009 11:38:00 am
  </code></pre>
  
  <p>What is the SQL syntax for getting something like this one? </p>
  
  <p><em>Date</em> <strong>Count</strong><br>
  <em>19/5/2009</em> <strong>2</strong><br>
  <em>20/5/2009</em> <strong>1</strong>  </p>