select 1 from dual where '2010-05-05' between '2010-05-05' and '2010-05-05'
上面这句sql能查询出结果。
select 1 from dual where '2010-05-05' between '2010-05-05 00:00:00' and '2010-05-05 23:59:59'
而这句SQL就查询不出结果。
这是什么原因?
select 1 from dual where '2010-05-05' between '2010-05-05' and '2010-05-05'
上面这句sql能查询出结果。
select 1 from dual where '2010-05-05' between '2010-05-05 00:00:00' and '2010-05-05 23:59:59'
而这句SQL就查询不出结果。
这是什么原因?
如果想比较字符的话,结果是正确的,第二条语句就应该没结果。 如果阁下想比较日期的话,就要用TO_DATE()将字符串转换成Date类型才行