Python Sqlite Error With Parsing Datetime String

Ive been trying to sort out how to import data into a sqlite table, I can do this but I seem to have an error issue with the date entries. Here is reproducible code that demonstra

Solution 1:

The .txt file seems to contain entries of type Date, and not Datetime. You could convert the data for the following rows into type Datetime as specified by sqlalchemy: Date - datetime description.

If all of your data in that column contains '2019-08-24' or 'YYYY-MM-DD' format then you can safely change your database column type to Column(Date).