By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT str_to_date('6/2/2018 3:00:00 PM', '%e/%c/%Y %l:%i:%s %p')
| str_to_date('6/2/2018 3:00:00 PM', '%e/%c/%Y %l:%i:%s %p') |
|---|
| 2018-02-06 15:00:00 |
| str_to_date('6/2/2018 3:00:00 PM', '%e/%c/%Y %l:%i:%s %p') |
|---|
| 2018-02-06 15:00:00 |