SELECT
DATE_ADD(
DATE_ADD(
DATE_ADD(
LAST_DAY(
STR_TO_DATE('2022-04-01', "%Y-%m-%d")
),
INTERVAL 1 DAY
),
INTERVAL - 1 MONTH
),
INTERVAL (
CAST(
help_topic_id AS SIGNED INTEGER
)
) DAY
) md
FROM
mysql.help_topic
WHERE
help_topic_id < DAY (
LAST_DAY(
STR_TO_DATE('2022-04-1', "%Y-%m-%d")
)
)
ORDER BY
help_topic_id
sql查询某月的每一天(日历)
于 2022-04-20 11:14:22 首次发布