title: Group and count by hour in sql
body: <p>I am trying to get group by hour and count but cannot group by hour field.</p>
  
  <pre><code>select t_date_time_issued,t_street_name,count(t_reference) from tickets 
  WHERE t_date_time_issued BETWEEN '03/06/2015' AND '03/07/2015'  and t_street_name like '%airport%'
  GROUP BY t_street_name,t_reference,t_date_time_issued
  order by t_date_time_issued
  </code></pre>
  
  <p>Current output</p>
  
  <pre><code>2015-06-03 09:34:25.000 Airport (60/100 14 Day) 1
  2015-06-03 09:38:06.000 Airport (60/100 14 Day) 1
  2015-06-03 10:09:06.000 Airport (60/100 14 Day) 1
  2015-06-03 10:14:16.000 Airport (60/100 14 Day) 1
  2015-06-03 10:28:25.000 Airport (60/100 14 Day) 1
  </code></pre>
  
  <p>Instead I want to get:</p>
  
  <pre><code>2015-06-03 09:00:00.000 Airport (60/100 14 Day) 2
  2015-06-03 10:00:00.000 Airport (60/100 14 Day) 3
  </code></pre>