title: Rounding Datetime to nearest 15 minutes in SQL Server
body: <p>I have a problem in SQL Server with rounding <code>datetime</code>. I got <code>datetime</code> in column <code>rec_datetime</code>, but I want to round this <code>datetime</code> in a new column <code>r_datetime</code>, which has to be rounded to nearest 15 min, for the whole column <code>rec_datetime</code>.</p>
  
  <p><strong>Example:</strong></p>
  
  <ul>
  <li><code>[2015-11-24 19:06:00.000]</code> - expected result ->  <code>[2015-11-24 19:00:00.000]</code></li>
  <li><code>[2015-11-24 19:09:00.000]</code> - expected result ->  <code>[2015-11-24 19:15:00.000]</code></li>
  </ul>
  
  <p>Is it possible to round it via select for whole column? Something like : </p>
  
  <pre><code>select round(rec_datetime.......
  </code></pre>