Hello I have the following column and I want to order it by date from earliest to latest. the format looks like this.
08/16/2019 08:09:51 AM
I came up with this but its giving me an error.
ORDER BY date_format(STR_TO_DATE(`END_TIME`,'%m-%d-%y %h:%i:%s %p'),'%Y-%m-%d %H:%i:%s')
I couldn't strictly order it by date because 2 PM came before 8 AM which is wrong so I tried to put it in the correct format, I feel like im close. Any ideas?