title: Group by 24 hour and Day of week - time interval
body: <p>I know this is a common question, but I couldn't find something that matches my case. So here we go.</p>
  
  <p>I have a table named RECORDED_ENTRIES that has columns ID (int) and CreateDate (datetime).</p>
  
  <p>I want to group data by hour on a 24hour basis regardless of the actual date. </p>
  
  <p>For example I want the output to be:</p>
  
  <pre><code>00:00 - 2
  01:00 - 3
  02-00 - 12
  ....
  23:00 - 1
  </code></pre>
  
  <p>The aim is to create data for a chart that will display recorded entries by the hour of day</p>
  
  <p>I need to group also data by the name of Day.</p>
  
  <p>Thanks</p>