select convert(datetime,substring(left('20170719172552',8)+' ' + substring('20170719172552',9,2)+':' + substring('20170719172552',11,2)+':' + substring('20170719172552',13,2),1,20))
select substring('D:\files,3,len('D:\files)-2)
--去掉前两位路径D:
select convert(datetime,substring(left('20170719172552',8)+' ' + substring('20170719172552',9,2)+':' + substring('20170719172552',11,2)+':' + substring('20170719172552',13,2),1,20))
select substring('D:\files,3,len('D:\files)-2)
--去掉前两位路径D: