Algorithm

DATE_ADD(
    '2022-10-01',
    Interval FLOOR(TIMESTAMPDIFF(DAY, '2022-10-01', date) / 2) * 2 DAY
) AS INTERVAL_DATA

Code Examples

#1 2 Day interval mysql data from 2022-10-01 date for graph or report

Code - MySQL


SELECT DATE_ADD(
    '2022-10-01',
    Interval FLOOR(
        TIMESTAMPDIFF(DAY, '2022-10-01', date) / 2) * 2 DAY
	) AS INTERVAL_DATA,

    SUM(total) AS totalData
FROM tableName
GROUP BY INTERVAL_DATA
Copy The Code & Try With Live Editor

#2 10 Minute interval data from 2022-10-01 date for graph or report

Code - MySQL


SELECT DATE_ADD(
    '2022-10-01',
    Interval FLOOR(TIMESTAMPDIFF(MINUTE, '2022-10-01', date) / 10) * 10 MINUTE
) AS INTERVAL_DATA,

    SUM(total) AS totalData
FROM tableName
GROUP BY INTERVAL_DATA
Copy The Code & Try With Live Editor

#3 1 Month interval data in mysql for graph or report

Code - MySQL


SELECT DATE_ADD(
    '2022-10-01',
    Interval FLOOR(TIMESTAMPDIFF(MONTH, '2022-10-01', date) / 1) * 1 MONTH
) AS INTERVAL_DATA,

    SUM(total) AS totalData
FROM tableName
GROUP BY INTERVAL_DATA
Copy The Code & Try With Live Editor
Advertisements

Demonstration

MySQL Get List of Data in specific Interval - Day Month Minute interval data for Graph