Change date string with "am/pm" to actual date in MySQL – Phpmyadmin
I have a column of dates written as strings with "am" and "pm" at the end, for example: 1/1/2016 12:00:00.000 AM The type of the column is currently varchar, I want to change the type to datetime format. Attempt 1…