更新时间:2022-06-06 17:05:22
改用 DATE_FORMAT:
Use DATE_FORMAT instead:
SELECT DATE_FORMAT('2000-07-10','%m-%d')
收益
07-10
这是您用 DATE_FORMAT()
重写的查询:
Here's your query re-written with DATE_FORMAT()
:
SELECT *
FROM table
WHERE DATE_FORMAT(field, '%m-%d') = DATE_FORMAT('2000-07-10', '%m-%d')
AND id = "1"