sql如何查询当天数据？

有个表里有个字段为addtime，精确到秒，就是检索出24小时之内的信息。

---

datediff(day,addtime,getdate())=0

---

SQL code:
ABS(datediff(DD,addtime,getdate()))=0

---

SQL code:
datediff(hh,col,dateadd(dd,1,col))=24

---

SQL code:
select * from tb where datediff(ss,addtime,getdate())>=24*60*60

---

不行啊。怪我没说清楚。
select count(ID) as num2 from test where Article_Id="&id&" order by ???
----
是这个语句怎么判断addtime为24小时内的数据啊。

---

select * from tb where datediff(ss,addtime,getdate())>=24*60*60

---

SQL code:
select count(ID) as num2 from test where Article_Id="&id&"
and addtime between DATEADD(day,-1,getdate()) and GETDATE()
order by ???

---

SQL code:

Select GETDATE(),DATEADD(day,-1,getdate())
/*

----------------------- -----------------------
2009-11