mysql 年，月，日

select * from `fnbl_user` where WEEK(last_name)=WEEK(now())；
 select * from `fnbl_user` where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(last_name); 周

  select * from `fnbl_user` where to_days(last_name) = to_days(now());  天

   select * from `fnbl_user`  where   Month(last_name)>=1 and Month(last_name)<=10  从几月到几月

   select * from `fnbl_user`  where   Month(last_name)=3             月   ,to_data,to_chart

    select * from `fnbl_user`   where year(last_name)=2009           年

 

 

SELECT uid,username,FROM_UNIXTIME(dateline),title_template FROM `uchome_feed` where icon='invite'  and  DATE( FROM_UNIXTIME(dateline))>='2009-03-02 ' and  DATE( FROM_UNIXTIME(dateline))<='2009-03-10 '  年月日 到 年月日