Re: How to round a datetime field

[Saggi Malachi]

Hi,
I think an easier way to do this would be:
select from_unixtime(round(unix_timestamp('2006-10-10 14:15:01')/(60*30))*(60*30));
select from_unixtime(round(unix_timestamp('2006-10-10 14:14:59')/(60*30))*(60*30));

You can of course replace 30 with any number of minutes you'd like to round to.
replacing ROUND with FLOOR might sometimes be useful as well.