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