ora-01861 格式不匹配

 

insert into XXXX(id,updateTime)values('1',to_date('2021/3/9 11:33:21','yyyy-mm-dd hh24:mi:ss'))

 将格式日期修改为:'yyyy/mm/dd hh24:mi:ss' 即可

insert into XXXX(id,updateTime)values('1',to_date('2021/3/9 11:33:21','yyyy/mm/dd hh24:mi:ss'))

原文地址:https://www.cnblogs.com/Apeak/p/14504737.html