mysql如何把日期截取到月和日,不要年
SELECT DATE_FORMAT('2022-05-01','%Y-%m-%d') as k1
,DATE_FORMAT('2022-05-01','%m-%d') as k2
,DATE_FORMAT('2022-05-01','%d') as k3
---------
DATE_FORMAT函数切换下输出格式即可实现!
-------------------
假设您有一个名为"date_column"的日期列: SELECT DATE_FORMAT(date_column, '%m-%d') AS truncated_dateFROM your_table;