title: Grouping a time field into 5 minute periods in SQL server
body: <p>I have a column of times and want to create a second column to show which 5 minute interval on a 24 hr clock they fall into. For example</p>
  
  <pre><code>15:19:52 becomes 15:15:00
  15:20:11 becomes 15:20:00
  </code></pre>