By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| STR_TO_DATE('1/1/2012 0:04', '%c/%e/%Y %k:%i') |
|---|
| 2012-01-01 00:04:00 |
| STR_TO_DATE('3/31/2012 23:56', '%c/%e/%Y %k:%i') |
|---|
| 2012-03-31 23:56:00 |
| STR_TO_DATE('1/1/2012 0:04', '%c/%e/%Y %k:%i') |
|---|
| 2012-01-01 00:04:00 |
| STR_TO_DATE('3/31/2012 23:56', '%c/%e/%Y %k:%i') |
|---|
| 2012-03-31 23:56:00 |