df.loc[0, 'ddate'] = '2023-08-29'
df.loc[0, 'drdate'] = '2023-08-29'
df.loc[0, 'ccode'] = ccode
df.loc[0, 'cverifier'] = 'NULL'
df.loc[0, 'dverifydate'] = 'NULL'
df.loc[0, 'dcreatesystime'] = '2023-08-29'
df.to_sql('SA_CusPriceJustMain', ENGINE, chunksize=1000, index=False, if_exists='append')
想将数据插入到Sql Server中,错误提示是日期转换出错:
(pymssql._pymssql.OperationalError) (241, b'Conversion failed when converting date and/or time from character string.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n')
[SQL: INSERT INTO [SA_CusPriceJustMain] (id, ddate, drdate, ccode, cmaker, cpersoncode, cmainmemo, ]) VALUES (%(id)s, %(ddate)s, %(drdate)s, %(ccode)s, ......
[parameters: {'id': 1000100000, 'ddate': datetime.datetime(2023, 8, 29, 0, 0), 'drdate': datetime.datetime(2023, 8, 29, 0, 0), 'ccode': 'SA23080007', ......