知道我的查询出了什么问题吗?我正在尝试更新数据库的一行,但是我正在使用的查询导致异常。UPDATE Table1SET CHANGE_DELIVERY_REASON = 'Card Activation',CHANGE_DELIVERY_NOTE = 'ACTIVATION SUCCESS [1 OK - 2 OK]',RECONCILIATION_STATUS = 1 ,RECONCILIATION_LAST_UPDATED = '23/4/2018 12:00:00 AM',RECONCILIATION_COUNT = '6',ACTIVATION_FAILURE = 'SUCCESS';我收到此错误:“ SQL错误:ORA-01843:无效月份”我没有弄清楚我的查询出了什么问题。updateQuery = " UPDATE " + clsUtility.GetMasterTable() + " SET ";updateQuery += " CHANGE_DELIVERY_REASON = 'Card Activation', ";updateQuery += " CHANGE_DELIVERY_NOTE = '" + notes + "', ";updateQuery += " RECONCILIATION_STATUS = 1 , ";updateQuery += " RECONCILIATION_LAST_UPDATED = '" + DateTime.Today + "', ";updateQuery += " RECONCILIATION_COUNT = '" + reconciliation_count + "',";updateQuery += " ACTIVATION_FAILURE = '" + resultPart + "', ";
3 回答
- 3 回答
- 0 关注
- 526 浏览
添加回答
举报
0/150
提交
取消