title: Get the ten minute intervals from a range of datetimes
body: <p>I have a datetime column with range of Datetime values. I want to create another column with all this datetime values but to round down to ten minute period.</p>
  
  <p>So, something like this:</p>
  
  <pre><code>datetimesent              |     ten_minute_column
  
  2012-06-11 18:27:58.000   |     2012-06-11 18:20:00.000
  2012-06-15 15:19:08.000   |     2012-06-15 15:10:00.000
  ...                       |
  </code></pre>
  
  <p>The farthest I have got is playing around with is getting it in minute bucket slots.
  I got this by doing:</p>
  
  <pre><code>SELECT DatetimeSent,
      DATEADD(Minute, DATEDIFF(Minute, 0, DatetimeSent), 0) AS Minute_bucket
  FROM allrequests
  </code></pre>
  
  <p>But I need ten minute bucket slots.</p>