Project 3 - Case Study 2

Hi, the date time values in datasets of case study 2 are not in proper format and I tried to change the format in sql it is giving error:1411 and when I try to convert using cast function it gives error 1292: incorrect datetime value. I rechecked with csv files and the date formats where all jumbled and not in proper format, so I had to change it to correct format in csv file and even then the problem in mysql still exists. I request you to help me with this. I have been trying to solve from 2 days and the error exists. Please refer to the attached screenshots.