Home Forums SQL Server 2008 SQL Server 2008 Administration Script to calculate when a job ended. RE: Script to calculate when a job ended.

  • March 11, 2013 at 9:38 am

    #1595628

    You have to cast run_duration to varchar first.

    Try

    STUFF(STUFF(RIGHT('000000'+CAST(run_duration as varchar(6)),6),5,0,':'),3,0,':')

    Far away is close at hand in the images of elsewhere.
    Anon.