一个关于日期查询的问题????
为何我总是查询不到数据?
---------------------------------------------
表名:[dx]如下:
ID RQ[datetime] MC GG
1 2007-07-04 22:12:10.000 MCMCMCMC GGGGGG
2 2007-07-03 21:10:12.00 DDDDDDDD FFFFFF

为何select * from dx where rq= '2007-07-04 '查询不到任何数据库???


[解决办法]
access:

select *
from dx
where format(rq. 'yyyy-mm-dd ')= '2007-07-04 '


SQL server:

select *
from dx
where convert(varchar(10),rq,120)= '2007-07-04 '