将从wps表格数据转成数组后保存mysql时报错，日期格式问题
将从wps表格数据转成数组后保存mysql时报错， 第16行：模块 Database.ExecuteBatchSQL 命令出错：ExecuteBatchSQL 异常： (1292, "Incorrect datetime value: 'date' for column 'date' at row 1")
以下是rpa代码：
Rem 下面开始构建数据表
行数=Excel.GetRowsCount(objExcelWorkBook,"常规核检明细表")
列数=Excel.GetColumsCount(objExcelWorkBook,"常规核检明细表")
标题=Excel.ReadRange(objExcelWorkBook,"常规核检明细表",[[1,1],[1,列数]],true)
数据=Excel.ReadRange(objExcelWorkBook,"常规核检明细表",[[2,1],[行数,列数]],false)
源数据数组=Unshift(数据,["Precincts","city","region","st_id","st_name","manager","score","date","grade","1.1","1.2","1.3","1.4","1.5","2.1","2.2","2.3.1","2.3.2","2.4.1","2.4.2","2.5","2.6","3.1","3.2","3.3","3.4","4.1","4.2.1","4.2.2","4.3","4.4","4.5","4.6"])
Rem 以上将下载的表处理后得到需要的数组
objDatabase = Database.CreateDB("MySQL",{"host": "*", "port": "*", "user": "root","password": "*==","database": "zhongjianbiao","charset": "utf8"})
If 今日天数=1
Rem 每月1日删除上个月全月数据更新全月
iRet = Database.ExecuteSQL(objDatabase ,"DELETE FROM city_check_data WHERE date >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), '%%Y-%%m-01') AND date < DATE_FORMAT(CURDATE(), '%%Y-%%m-01');", {"args": []})
Rem 删除掉SQL中相对系统日期上个月全月的数据，
Else
iRet = Database.ExecuteSQL(objDatabase ,"DELETE FROM city_check_data WHERE date=ADDDATE(CURDATE(),-1)", {"args": []})
Rem 删除掉SQL中相对系统日期上一日的数据，
End If
iRet = Database.ExecuteBatchSQL(objDatabase ,"insert into city_check_data (`Precincts`, `city`, `region`, `st_id`, `st_name`, `manager`, `score`, date, `grade`, `1.1`, `1.2`, `1.3`, `1.4`, `1.5`, `2.1`, `2.2`, `2.3.1`, `2.3.2`, `2.4.1`, `2.4.2`, `2.5`, `2.6`, `3.1`, `3.2`, `3.3`, `3.4`, `4.1`, `4.2.1`, `4.2.2`, `4.3`, `4.4`, `4.5`, `4.6`)VALUES (%s, %s, %s,%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);", {"args": 数据})
Rem 将相对系统日期上一日的处理后的数据保存到数据库
请大神帮忙看看是什么原因，同样的添加语句在mysql中换成实际值是可以添加的，但是在RPA中总是这样报错。下面是WPS的源数据。
最新回复 (4)
-
薇~ 11月前2楼
-
+86 181******01 11月前3楼
这个是要保存的sql的第一组值， -
+86 181******01 11月前4楼
直接保存到sql里是可以的，能正常运行，就是在RPA里就报错 -
+86 181******01 11月前5楼
帮忙看看啥原因，这个是要保存的值
薇~
亲~输出一下要传入数据库的值，确认一下输入的日期的数据的格式是否正常