- ## sql查询日期–当前日期倒退至上个月当天的日期列表查询
数据库:mysql5.7
SQL语句:直接在navicat中查询即可
SELECT
date_add(
date_sub(
(
SELECT
date_format(
DATE_SUB(now(), INTERVAL 30 DAY),
'%y-%m-%d'
)
),
INTERVAL 1 DAY
),
INTERVAL (
cast(help_topic_id AS signed) + 1
) DAY
) DAY
FROM
mysql.help_topic
WHERE
help_topic_id < DATEDIFF(
(SELECT curdate()),
date_sub(
(
SELECT
DATE_SUB(now(), INTERVAL 30 DAY)
),
INTERVAL 1 DAY
)
)
ORDER BY
help_topic_id