ERROR 1292 (22007) at line 225: Truncated incorrect date value: '12/16/1998 0:00:00'

[dfreder1]

Hi, thanks for creating this repository, I'm looking forward to sifting through this data.

Aircraft table is created, but getting an error while importing the csv file on the first datetime value it encounters in aircraft.csv.

It seems like the csv has an incorrect date format (12/16/1998 0:00:00 instead of 1998-12-16 00:00:00) although I tried hardcoding different date formats and still got the error.

MacOS, MySQL 8