我试图基于pandas数据帧创建sql表,但它返回以下错误:
'22007', '[22007] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. (242) (SQLExecDirectW); [22007] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. (3621)', Tipo: <class 'pyodbc.DataError'>
奇怪的是,在某些机器中会出现错误,所以我怀疑这是驱动程序配置
df['dtref']=dtref.strftime('%Y-%m-%d')
df['dtref']=pd.to_datetime(dtref,format='%Y-%m-%d')
Obs:dtref变量是python中的日期时间
有人能帮我吗
谢谢
目前没有回答
相关问题 更多 >
编程相关推荐