mysql获取时间范围内的所有日期
2021-11-25 本文已影响0人
King斌
获取最近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
