1、select * from tablename where cast(year(datetime字段) as varchar)+cast(month(datetime字段) as varchar)='某年某月'
2、select * from tablename where year(datetime字段)=某年
3、select * from tablename where month(datetime字段)=某月
4、select * from tablename where day(datetime字段)=某日