一个关于日期查询的问题????
为何我总是查询不到数据?
---------------------------------------------
表名:[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 '
