ORA-01841: (完整) 年份值必须介于 -4713 和 +9999 之间, 且不为 0

Question

("insert into mw_app.MWT_UD_JXRWBL_INFO(ID,YXJHSQ_BH,YXJHSQ_JHMC,YXJHSQ_ZYGZNR,YXJHSQ_JHKSSJ,YXJHSQ_YXYW,YXJHSQ_TBR,"+
"YXJHSQ_SJSJGS,YXJHSQ_SLSJ,FLAG,YXJHSQ_TBDW,YXJHSQ_TBRDLM,C_USERID)values((select sys_guid() from dual),'"+checkValue(flag)+"','"+checkValue(jhmcArr[i])+"','"+checkValue(zygznrArr[i])+"','','"+checkValue(yxywArr[i])+
"','"+checkValue(tbrArr[i])+"','"+checkValue(sjsjgdArr[i])+"',to_date('"+checkValue(blsjArr[i])+"','yyyy-mm-dd hh24:mi:ss'),'"+checkValue(flag)+"','"+checkValue(tbdwArr[i])+"','"+checkValue(tbrdlmArr[i])+"','"+checkValue(mw.Portal.currentUser.id)+"')");
这是原sql

Caused by: nariis.pi3000.framework.data.DataAccessException: 执行SQL[insert into mw_app.MWT_UD_JXRWBL_INFO(ID,YXJHSQ_BH,YXJHSQ_JHMC,YXJHSQ_ZYGZNR,YXJHSQ_JHKSSJ,YXJHSQ_YXYW,YXJHSQ_TBR,YXJHSQ_SJSJGS,YXJHSQ_SLSJ,FLAG,YXJHSQ_TBDW,YXJHSQ_TBRDLM,C_USERID)values((select sys_guid() from dual),'临时任务','null','null','','null','null','[{"strat_time":"2015-12-27 18:30","end_time":"2015-12-27 20:30"}]',to_date('null','yyyy-mm-dd hh24:mi:ss'),'临时任务','null','null','8697D72E-C77B-4C70-A434-ED7D488ADC36')]时发生异常

Answer 1

一般出现这个问题，都是字符串转化为日期格式，字符串不符合日期格式，检查下字段