select * from XXAE_REPAY where REPAY_DATE = '2008/08/14'select * from XXAE_REPAY 明明有数据,并且REPAY_DATE的值是:2008/08/14 17:00:47
我条件查询,select * from XXAE_REPAY where REPAY_DATE = '2008/08/14',为什么没有值呢???
我条件查询,select * from XXAE_REPAY where REPAY_DATE = '2008/08/14',为什么没有值呢???
select * from XXAE_REPAY where REPAY_DATE = to_date('2008/08/14','yyyy/mm/dd');
select *
from XXAE_REPAY
where REPAY_DATE LIKE '2008/08/14%'
因此可以推断REPAY_DATE字符型,不是日期型。
REPAY_DATE DATE NOT NULL,
select * from XXAE_REPAY where trunc(REPAY_DATE) = to_date('2008/08/14','yyyy/mm/dd');
这个好用,谢谢了!