从sql server读取最大日期，从日期中减去指定的天数，并根据python中的新日期重新加载数据

Question

已建立连接并测试到SQL服务器。我从数据库中获取max date并减去天数，然后根据新日期获取最新记录并将其写入CSV但是我得到了这个错误有解决方案吗

代码：

query="select max("+Refresh_col+") from "+table_name

date=pd.read_sql(query,cnxn)

print(date)

a=date-timedelta(days=10)

print(a)

query= ("select "+','.join(col_csv)+ " from "+table_name+" where " +Refresh_col+">=?")

params=(a)

pd.read_sql(query,cnxn,params).to_csv("C:\\Users\\user\\Desktop\\RMS_Data_load\\tes1.csv",index=False) 

错误：

Execution failed on sql 'select RID,RefID,RefType,RequestedBy,RequestedOn,ApprovalTo,ApprovedOn,ApprovalStatus,Notes from table_name where RequestedOn>=?': ('07002', '[07002] [Microsoft][ODBC Driver 13 for SQL Server]COUNT field incorrect or syntax error (0) (SQLExecDirectW)')