用SQL语句把14位字符串转换成时间

比如201204191234转换成2012-04-19 12:34:00

---

提供两个简单方做没衫法，转换纯腔出来的是完全兼容的时间格式，请参考：

mysql> set @str:="201204191234";
Query OK, 0 rows affected (0.02 sec)

mysql> select date_format(concat(@str, "00"察型), "%Y-%m-%d %H:%i:%S");
+------------------------------------------------------+
| date_format(concat(@str, "00"), "%Y-%m-%d %H:%i:%S") |
+------------------------------------------------------+
| 2012-04-19 12:34:00 |
+------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select from_unixtime(unix_timestamp(concat(@str, "00")));
+---------------------------------------------------+
| from_unixtime(unix_timestamp(concat(@str, "00"))) |
+---------------------------------------------------+
| 2012-04-19 12:34:00 |
+---------------------------------------------------+
1 row in set (0.00 sec)

---

oracle的话可销晌以侍斗告：
select to_char(to_date('老明201204191234','yyyymmddhh24mi'),'yyyy-mm-dd hh24:mi:ss') str from dual

---

select convert(varchar(10), substring('201204191234',1,4))+'-'+convert(varchar(10), substring('201204191234'尺做,5,2))+'吵态-'+convert(varchar(10), substring('201204191234'陵碰衡,7,2))+' '+convert(varchar(10), substring('201204191234',9,2))+':'+convert(varchar(10), substring('201204191234',11,2))+':'+'00'

---