Group mysql query by 15 min intervals September 3, 2022 by Tarik SELECT FLOOR(UNIX_TIMESTAMP(timestamp)/(15 * 60)) AS timekey FROM table GROUP BY timekey;