关于日期到期查询的问题

[mrbai]

我从biaozhun库中间查取b_yxq字段，字段类型datetime
我想查询本月到期的内容我用了如下两种方法，都有点问题，大家帮忙看看问题在什么地方
select * from [biaozhun] where datediff("d",b_yxq,getdate())<30

select * from [biaozhun]WHERE (b_yxq < GETDATE() - 30)

[青锋-SS]

select * from [biaozhun] where datediff(d,b_yxq,getdate()) <30 

select * from [biaozhun] WHERE (b_yxq  < dateadd(d,- 30,GETDATE() ) 

[青锋-SS]

select * from [biaozhun] where datediff(d,b_yxq,getdate()) <30 

select * from [biaozhun] WHERE b_yxq  < dateadd(d,- 30,GETDATE() ) 

[wzy_love_sly]

select * from [biaozhun] 
where datediff(dd,b_yxq,getdate()) <30 

[-狙击手-]

我想查询本月到期



select *
from [biaozhun]
WHERE datediff(m,b_yxq,GETDATE()) = 0

[areswang]

select * from [biaozhun] where datediff(d,b_yxq,getdate()) <30

[RoverX]

select * from [biaozhun] where b_yxq>= convert(varchar(7),getdate(),120)+'-01' and b_yxq<convert(varchar(7),dateadd(mm,1,getdate()),120)+'-01'

[ojuju10]

select * from [biaozhun] where datediff(d,b_yxq,getdate()) <30  

[ojuju10]

查询本月到期 

select * from biaozhun where datediff(mm,b_yxq,getdate)=0

[hui_hui_2007]

关注。

[byg1983109]

select * from [biaozhun] where datediff(day,b_yxq,getdate())<30

[JL99000]

select * from [biaozhun] where datediff("d",b_yxq,getdate()) <30
--
select * from [biaozhun] where datediff( d,b_yxq,getdate()) <30

select * from [biaozhun]WHERE (b_yxq < GETDATE() - 30)
--
select * from [biaozhun] WHERE b_yxq < (GETDATE()-30)