获取最近12个月

SELECT DATE_FORMAT(DATE_ADD(
CONCAT(YEAR(DATE('2018-12-01')),'-01-01'),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) MONTH ),'%Y-%m') month
FROM mysql.help_topic
WHERE help_topic_id < 12 ORDER BY month ASC ;

图片.png

获取最近30天

SELECT DATE_FORMAT(DATE_ADD(
CONCAT(YEAR(DATE('2018-12-01')),'-01-01'),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) DAY ),'%Y-%m-%d') month
FROM mysql.help_topic
WHERE help_topic_id < 30 ORDER BY month ASC ;

图片.png

获取最近24小时

SELECT DATE_FORMAT(DATE_ADD(
CONCAT(YEAR(DATE('2018-12-01')),':01:01'),INTERVAL (CAST( help_topic_id AS SIGNED INTEGER )) HOUR ),'%Y-%m-%d %H') month
FROM mysql.help_topic
WHERE help_topic_id < 24 ORDER BY month ASC ;

图片.png