mysql查询本月的注册用户怎么写

[Iknowurcode]

mysql查询本月的注册用户怎么写
user表 pudate(int) 是时间字段 谢谢各位老大

[Iknowurcode]

我在网上找了好几个都实现不了

[ACMAIN_CHM]

select * from `user` where DATE_FORMAT(pudate,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m') ;

[Iknowurcode]

好像还是没有数据 本周有数据
select * from user where WEEKOFYEAR(FROM_UNIXTIME(pudate,'%y-%m-%d')) = WEEKOFYEAR(now())

[百年树人]

[Quote=引用 3 楼 Iknowurcode 的回复:]
好像还是没有数据 本周有数据
select * from user where WEEKOFYEAR(FROM_UNIXTIME(pudate,'%y-%m-%d')) = WEEKOFYEAR(now())
[/Quote]

select * 
from user 
where MONTH(FROM_UNIXTIME(pudate,'%y-%m-%d')) = MONTH(now())

[百年树人]

--加上年份的判断
select * 
from [user] 
where YEAR(FROM_UNIXTIME(pudate,'%y-%m-%d')) = YEAR(now())
and MONTH(FROM_UNIXTIME(pudate,'%y-%m-%d')) = MONTH(now())

[hqq01025]

[Quote=引用 5 楼 josy 的回复:]
SQL code--加上年份的判断
select *
from [user]
where YEAR(FROM_UNIXTIME(pudate,'%y-%m-%d')) = YEAR(now())
and MONTH(FROM_UNIXTIME(pudate,'%y-%m-%d')) = MONTH(now())
[/Quote]
赞同

[pangpangxu]

select * 
from [user] 
where pudate between 上月最后一天
and 下月第一天

其中上月最后一天和下月第一天由应用程序计算得到，最好pudate上有索引