Skip to content Skip to sidebar Skip to footer

Pyodbc Import Error Because Of Invalid Datetime Format

I´ve already look it up here, but couldn´t find a solution for my problem. I want to get a dataframe from 4 accces databanks and 2 work with this exact code and the other 2 displ

Solution 1:

So I finally find the answer. I selected the Error showing column and import it as a string. I just wrote:

df = pd.read_sql_query(sql='SELECT ID, ..., Cstr(dtime), dates FROM TB_cycles_car', con=conn)

The DataError didn´t show up anymore :) Thanks a lot @GordThompson for helping!


Post a Comment for "Pyodbc Import Error Because Of Invalid Datetime Format"