表user
------
user addtime
wlm 1373038390
------------------
查询本周(周一到周日)新注册会员的数量,addtime是字符型时间戳,这个要怎么查呢。一段时间内的我好像会了,一周的怎么弄呀。
------
user addtime
wlm 1373038390
------------------
查询本周(周一到周日)新注册会员的数量,addtime是字符型时间戳,这个要怎么查呢。一段时间内的我好像会了,一周的怎么弄呀。
from user
where addtime > UNIX_TIMESTAMP( curdate()-interval WEEKDAY(curdate()) day)
select *
from user
where week(addtime,1)=week(UNIX_TIMESTAMP(curdate()),1)
select * from user where weekofyear(addtime)=weekofyear(NOW()) ;