• An alternative, using DATEADD and CONVERT

    select CONVERT (varchar(8),DATEADD(second,@duration,0),114)