Home Forums SQL Server 2008 T-SQL (SS2K8) Need help in calculating the RUNTIME of my Job's ETL RE: Need help in calculating the RUNTIME of my Job's ETL

  • December 23, 2012 at 3:43 pm

    #1571195

    Never mind I figure out a way to get the right Datetime...

    convert(varchar(5),DateDiff(s, Start.WorkQueueStartWorkDate,Finish.WorkQueueEndWorkDate)/3600)+':'+convert(varchar(5),DateDiff(s, Start.WorkQueueStartWorkDate,Finish.WorkQueueEndWorkDate)%3600/60)+':'+convert(varchar(5),(DateDiff(s, Start.WorkQueueStartWorkDate,Finish.WorkQueueEndWorkDate)%60)) as [hh:mm:ss]