数据库中有个日期字段值为2009-5-29
用 select * from zhangmu where IDATE = 2009-5-29 居然查不到但是 select * from zhangmu where IDATE > 2009-5-28 可以查出
select * from zhangmu where IDATE > 2009-5-29 居然也可以(怪事啊,不是要>=吗?)
select * from zhangmu where IDATE > 2009-5-1 and IDATE < 2009-6-1 也查不出来为啥啊??分不多还请各位见谅,先谢谢了
用 select * from zhangmu where IDATE = 2009-5-29 居然查不到但是 select * from zhangmu where IDATE > 2009-5-28 可以查出
select * from zhangmu where IDATE > 2009-5-29 居然也可以(怪事啊,不是要>=吗?)
select * from zhangmu where IDATE > 2009-5-1 and IDATE < 2009-6-1 也查不出来为啥啊??分不多还请各位见谅,先谢谢了
select * from zhangmu where IDATE > #2009-5-28#
以前我都是用SQL SERVERk的,从来也没出过这个问题IDATE = '2009-5-29' 程序会报错:数据类型不匹配