把“空格”、“:”替换掉,再加两个零
mysql> select DATE_FORMAT('20060507083000','%Y-%m-%d %H:%i:%s');
+---------------------------------------------------+
| DATE_FORMAT('20060507083000','%Y-%m-%d %H:%i:%s') |
+---------------------------------------------------+
| 2006-05-07 08:30:00 |
+---------------------------------------------------+
mysql> select DATE_FORMAT('20060507083000','%Y-%m-%d %H:%i:%s');
+---------------------------------------------------+
| DATE_FORMAT('20060507083000','%Y-%m-%d %H:%i:%s') |
+---------------------------------------------------+
| 2006-05-07 08:30:00 |
+---------------------------------------------------+
试试变通的吧
select date_add(concat(date_add(substring("20060502 08:30",1,8),interval 0 day)
,substring("20060502 08:30",9,9)),interval 0 minute);