<div>
Hai,<br />
<br />
thanks for ur reply. both works well. splitted the points. once again thanks for ur help.<br />
<br />
regards,<br />
MSKumar
</div>


Hai,

thanks for ur reply. both works well. splitted the points. once again thanks for ur help.

regards,
MSKumar

<div>
<div class="content wysiwyg-content">
Hai,<br />
<br />
Is there any function ( or an efficient way) to get the following functionality in mysql.<br />
<br />
2005-11-10 22:31:12 as 2005-11-10 22:35<br />
2005-11-10 22:34:13 as 2005-11-10 22:35<br />
2005-11-10 22:43:13 as 2005-11-10 22:45<br />
2005-11-10 22:47:13 as 2005-11-10 22:50.<br />
<br />
Its nothing but a ceiling based on 5 minutes.<br />
<br />
Please help.<br />
<br />
regards,<br />
MSKumar<br />

</div>
</div>


Hai,

Is there any function ( or an efficient way) to get the following functionality in mysql.

2005-11-10 22:31:12 as 2005-11-10 22:35
2005-11-10 22:34:13 as 2005-11-10 22:35
2005-11-10 22:43:13 as 2005-11-10 22:45
2005-11-10 22:47:13 as 2005-11-10 22:50.

Its nothing but a ceiling based on 5 minutes.

Please help.

regards,
MSKumar


mysql timestamp ceiling to 5 minutes

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.