MySQL convert Varchar to DateTime

Question

Trying to convert MySQL varchar field in this format

"07/25/2002 16:15" 

to correct MySQL datetime format

I tried the many variations of the STR_TO_DATE but still getting "Incorrect datetime value" errors.

Answer 1

SELECT STR_TO_DATE('07/25/2002 16:15','%m/%d/%Y %H:%i');

returns

2002-07-25 16:15:00

Answer 2

I think this should do it:

STR_TO_DATE(colname, '%m/%d/%Y %H:%i')