select * from a where a.in_date='22-Feb-2009' 改为select * from a where a.in_date=to_date('22-2-2009','dd-mm-yyyy')
select * from v$nls_parameters; 看下日期 格式 alter session set NLS_DATE_LANGUAGE='AMERICAN' 再试下
要改SQLPLUS的日志格式,并修改其语言ALTER SESSION SET NLS_LANGUAGE=AMERICAN; ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';select * from a where a.in_date='22-Feb-2009';
改为select * from a where a.in_date=to_date('22-2-2009','dd-mm-yyyy')
看下日期 格式
alter session set NLS_DATE_LANGUAGE='AMERICAN'
再试下
ALTER SESSION SET NLS_DATE_FORMAT='DD-MON-YYYY';select * from a where a.in_date='22-Feb-2009';