SELECT
DATE_FORMAT(
SUBDATE(
NOW(),
INTERVAL help_topic_id MONTH
),
'%Y-%m-%d'
)
FROM
mysql.help_topic
WHERE
help_topic_id < 12
距离当前时间的日期sql
最新推荐文章于 2022-06-05 21:52:01 发布
SELECT
DATE_FORMAT(
SUBDATE(
NOW(),
INTERVAL help_topic_id MONTH
),
'%Y-%m-%d'
)
FROM
mysql.help_topic
WHERE
help_topic_id < 12