Group mysql query by 15 min intervals

April 23, 2023 by Tarik

SELECT   FLOOR(UNIX_TIMESTAMP(timestamp)/(15 * 60)) AS timekey
FROM     table
GROUP BY timekey;