Re: Why is STR_TO_DATE failing?

[Peter Brawley]

SELECT STR_TO_DATE( '5/7/1977 00:00:00',  '%m/%d/%Y %H:%i:%s' );  
+----------------------------------------------------------+
| STR_TO_DATE( '5/7/1977 00:00:00',  '%m/%d/%Y %H:%i:%s' ) |
+----------------------------------------------------------+
| 1977-05-07 00:00:00                                      |
+----------------------------------------------------------+

Change %h to %H.

Note that it's unsound and inefficient to store datetime values in MySQL as US-formatted varchars.