More than 5 years have passed since last update.

MySQLで5分毎、10分毎の集計

Posted at 2016-09-03

select from_unixtime(round(unix_timestamp(created_at) div (5 * 60)) * (5 * 60)) as timekey from waitings group by timekey;

select from_unixtime(round(unix_timestamp(created_at) div (10 * 60)) * (10 * 60)) as timekey from table group by timekey;