当天查询？？

[庄子]

我用SQL SERVER里面通过NOW()函数存储时间， 我现在想以当天为查询条件，该怎么写SELECT语句

[xac17666]

select * from tablename where datediff(day,begintime,getdate())=0

[egg_server]

strdate=spilt(now()," ")
select * from table where [date] like '%strdate(0)%'

[jhwcd]

select * from tablename where  datediff(day,AddTime,getdate())=0