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

("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')]时发生异常

sql
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问