select convert(char(4),'20040729140802')+'-'
+substring('20040729140802',5,2)+'-'
+substring('20040729140802',7,2)+' '
+substring('20040729140802',9,2)+':'
+substring('20040729140802',11,2)+':'
+substring('20040729140802',13,2)楼主是不是想要这样的!
+substring('20040729140802',5,2)+'-'
+substring('20040729140802',7,2)+' '
+substring('20040729140802',9,2)+':'
+substring('20040729140802',11,2)+':'
+substring('20040729140802',13,2)楼主是不是想要这样的!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货