Getting pyodbc.ProgrammingError: ('ODBC SQL type -155 is not yet supported. column-index=0 type=-155', 'HY106')

Viewed 12

Getting the below error, When i try to query a table with date time, get the max date and assign the value to a variable.

pyodbc.ProgrammingError: ('ODBC SQL type -155 is not yet supported. column-index=0 type=-155', 'HY106')

code:

cursor.execute(max_dt_sql)
max_dt=cursor.fetchone()
print(max_dt)```

I tried to put it in a df and read from there but getting the same error. can you let me know how to handle this
0 Answers
Related