摘要： select job_name, run_datetime,SUBSTRING(run_duration, 1, 2) + ':' + SUBSTRING(run_duration, 3, 2) + ':' +SUBSTRING(run_duration, 5, 2) AS run_durationfrom(select job_name, DATEADD(hh, -7, run_datetime) as run_datetime, run_duration = RIGHT('000000' + CONVERT(varchar(6), h.run 阅读全文