关于SQL查询日期的问题

[guofu007]

select * from useinfo where landdate=###
我想查找日期是本月的所有记录该怎么查呢

[Clove]

select * from useinfo where Year(landdate)=Year(getdate()) and Month(landdate)=Month(getdate())

[baikaishui_0825]

select * from useinfo where datediff(month,landdate,getdate())>0

[cailover]

select * from useinfo where datediff(month,landdate,getdate())=0

[ygjwjj]

select * from useinfo where datediff(m,landdate,getdate())>0

[叮咚叮咚叮叮咚]

select * from useinfo where datediff(m,landdate,getdate())=0

select * from useinfo where Year(landdate)=Year(getdate()) and Month(landdate)=Month(getdate())

[叮咚叮咚叮叮咚]

如果是access的话getdate()换成date()

[oubao]

select * from useinfo where DATEDIFF( Month ,landdate ,Getdate() ) = 0

[Batistuta0614]

如果是ACCESS
select * from useinfo where DATEDIFF( Month ,landdate ,Getdate() ) = 0
要写成
select * from useinfo where DATEDIFF( “M” ,landdate ,date() ) = 0

[xczhouyang]

select * from useinfo where DATEDIFF( Month ,landdate ,now() ) = 0