现在我的数据库中有EditionDate这项
举个例子,我想搜索从2001-1-1到2008-12-31之内出版的书
我用如下语句
select * From Book where EditionDate>(2001-1-1) and EditionDate(2001-1-1),是可以搜出结果的
急救!
时间要有单引号的,不然实际执行的是算术运算select * From Book where EditionDate>(2001-1-1) 等同于select * From Book where EditionDate>19991999可以隐式转换为日期,所以有结果。正确写法是select * From Book where EditionDate>'2001-1-1' and EditionDateto_date('2001-1-1','yyyy-MM-dd') and EditionDate timestamp '2001-1-1'AND EditionDate '2001-1-1' and EditionDate(2001-1-1) or EditionDate<(2008-12-31)...