Oracle11g11.2
Oracle数据库字符集和导入的dump的字符集不一致时,对日期的隐形转化有影响;
如
declare
ld_date := '2019/04/01';
select * from D0010 where insertdate = :ld_date;
执行上面sql时回报ORA-01861:literal does not match format string
因为USA日期格式是dd-yy-mm/CN日期格式是YYYY-MM-DD
所以为了避免以上错误发生将sql语句修改wei
select * from D0010 where insertdate = to_date(:ld_date,'YYYY-MM-DD');