查询当天数据??

[haijun1130]

从一表中查询当天数据
select * from table where riqi<='2005-11-23'(当天日期是系统日期)
请问怎么写?
我想这么写,但错误.帮帮忙!!
select * from table where riqi<=date

[paoluo]

select * from table where DateDiff(dd,riqi,GetDate())=0

[点点星灯]

--查询当天数据
select * from table where datediff(day,riqi,getdate())=0

[churchatp1]

select * from table where datediff(day,riqi,getdate())=0

[zlp321002]

select
*
from
表
where
datediff(day,日期字段,Getdate())=0

[churchatp1]

如果要效率高一点就
select * from table where riqi>=convert(char(10),getdate(),120)
and riqi<convert(char(10),getdate()+1,120)
相对于上面的写法效率要高一些