mysql> SELECT STR_TO_DATE('20130501000000', '%Y%m%d%H%i%s');
-> '2013-05-01 00:00:00'