sql语句
SELECT * FROM table WHERE DATE_FORMAT(date, format) = ‘value’
注意:table 为表名,date为日期字段,format为格式,格式表如下;value为条件值
根据日查:
SELECT * FROM table WHERE DATE_FORMAT(date, “%d”) = ‘01’
根据月日查:
SELECT * FROM table WHERE DATE_FORMAT(date, “%m%d”) = ‘0201’
其他查询方式以此类推
