你可以 select * from register where year(zhucetime)*100+month(zhucetime) =201112 或者 select userid,username from register where DATE_FORMAT(zhucetime,'%Y-%m') ='2012-02'但不建议以上两种方法,无法利用索引查询,考虑到查询效率则应该在程序中实现两个变量。 select userid,username from register where zhucetime between '2012-02-01' and '2012-03-01'
这个可以用 DATE_FORMAT(res_date,'%Y-%m-%d')函数来做, 比如select userid,username from register where DATE_FORMAT(zhucetime,'%Y-%m') ='2012-02'
select userid,username from register where date_format(zhucetime,'%Y-%m')='2012-02';
select * from register where year(zhucetime)*100+month(zhucetime) =201112
或者
select userid,username from register where DATE_FORMAT(zhucetime,'%Y-%m') ='2012-02'但不建议以上两种方法,无法利用索引查询,考虑到查询效率则应该在程序中实现两个变量。
select userid,username
from register
where zhucetime between '2012-02-01' and '2012-03-01'
比如select userid,username from register where DATE_FORMAT(zhucetime,'%Y-%m') ='2012-02'