sqlserver yyyyMMddHHmmss格式 转换为 日期格式

SELECT MAX(study_uid_id) FROM datax_status_time where

–yyyyMMddHHmmss格式 转换为 日期格式

SELECT * FROM datax_status_time where convert(datetime,substring(left(time,8)+’ ’ + substring(time,9,2)+‘:’ + substring(time,11,2)+‘:’ + substring(time,13,2),1,17)) < dateadd(dd,-1,getdate())

SELECT convert(datetime,substring(left(time,8)+’ ’ + substring(time,9,2)+‘:’ + substring(time,11,2)+‘:’ + substring(time,13,2),1,17))
FROM datax_status_time

SELECT replace(replace(replace(convert(varchar,dateadd(ss,-41,convert(datetime,substring(left(time,8)+’ ’ + substring(time,9,2)+‘:’ + substring(time,11,2)+‘:’ + substring(time,13,2),1,20))),120),‘-’,‘’),‘:’,‘’),’ ‘,’')
FROM datax_status_time