mysql中类似Oracle的to_date

ORACLE:

select to_date('20190808123456','YYYY-MM-DD HH24:MI:SS') from dual;

TO_DATE('2019080812
-------------------
2019-08-08 12:34:56

MYSQL:

select str_to_date('20190808123456','%Y%m%d %H%i%s') from dual;

+-----------------------------------------------+
| str_to_date('20190808123456','%Y%m%d %H%i%s') |
+-----------------------------------------------+
| 2019-08-08 12:34:56                           |
+-----------------------------------------------+

注意 %h为12H制  %H 为24小时制