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:
本文共 299 字,大约阅读时间需要 1 分钟。
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:
转载于:https://www.cnblogs.com/Warmsunshine/p/7214317.html