原因为:
在使用Oracle的to_date函数来做日期转换时,很多Java程序员也许会直接的采用“yyyy-MM-dd HH:mm:ss”的格式作为格式进行转换,但是在Oracle中会引起错误:“ORA 01810 格式代码出现两次
oracle 支持的格式为
yyyy-MM-dd hh24:mi:ss
--错误代码
UPDATE
MP_BROKEN_SCREEN_TRADE T
SET
T.STATE =
'30'
,
T.T_INSRNC_BGN_TM = TO_DATE(
'2017-07-20 00:00:00'
,
'yyyy-MM-dd HH:mm:ss'
),
T.T_INSRNC_END_TM = TO_DATE(
'2018-07-19 23:59:59'
,
'yyyy-MM-dd HH:mm:ss'
),
T.POLICY_URL =
'http://58.251.33.182:18080/elec/netSaleQueryElecPlyServlet?c_ply_no=1M100084920171005450&idCard=411722197202132411'
,
T.UPDATE_DATE =
SYSDATE
WHERE
T.STATE =
'20'
AND
T.C_PLY_NO =
'1M100084920171005450'
--修改后代码
UPDATE
MP_BROKEN_SCREEN_TRADE T
SET
T.STATE =
'30'
,
T.T_INSRNC_BGN_TM = TO_DATE(
'2017-07-20'
,
'yyyy-MM-dd hh24:mi:ss'
),
T.T_INSRNC_END_TM = TO_DATE(
'2018-07-19'
,
'yyyy-MM-dd hh24:mi:ss'
),
T.POLICY_URL =
'http://58.251.33.182:18080/elec/netSaleQueryElecPlyServlet?c_ply_no=1M100084920171005450&idCard=411722197202132411'
,
T.UPDATE_DATE =
SYSDATE
WHERE
T.STATE =
'20'
AND
T.C_PLY_NO =
'1M100084920171005450'