高手们抢分了access的日期怎么比较我用的select*frompersonswhere[date]2007-10-10不对用select*frompers
高手们抢分了access的日期怎么比较
我用的
select * from persons where [date]> '2007-10-10 '
不对
用
select * from persons where [date]> 2007-10-10
不准
应该怎么判断呢
[解决办法]
select * from persons where [date]> = #2007-10-10#
[解决办法]
select * from persons where [date]> #2007-10-10#