title: MYSQL Round the datetime to 15 minute
body: <p>I want to update the datetime round to 15 minutes in a MYSQL database table.</p>
  
  <p>For Example:</p>
  
  <p>If the dateTime is <code>2013-10-08 10:36:00</code>, I want to convert it into <code>2013-10-08 10:30:00</code>
  Similarly,<code>2013-10-08 10:22:00</code> to <code>2013-10-08 10:15:00</code></p>
  
  <p>I have seen <a href="https://stackoverflow.com/questions/12835768/rounding-time-to-the-nearest-15-minutes-in-php-mysql">this</a> answer but it converts datetime into seconds and return time only, I want date as well.</p>
  
  <p>Thanks </p>