select * from tbname where datediff(dd,'2008-03-20',getdate())>30   天
select * from tbname where datediff(mm,'2008-04-20',getdate())>0   月