记录如下：
khzj khsj
16 2012-01-26 23:11:18.280
17 2012-01-26 23:11:21.750
18 2012-01-26 23:11:25.187
19 2012-01-26 23:11:31.233
20 2012-01-26 23:11:34.937
21 2012-01-26 23:11:38.123
22 2012-01-27 14:26:48.500
23 2012-01-27 14:28:51.967
24 2012-01-27 14:32:05.890
25 2012-01-27 14:33:47.373
26 2012-01-27 14:36:15.343
-------------------------
我想查询当日的记录，用GETDATE()什么也查不出来
select * from t where khsj=getdate()
改怎样写才能查出当日的记录呢？
------解决方案--------------------
- SQL code
select * from t where datediff(day,khsj,getdate())=0