UFN_MKTSEGMENTPASSIVE_GETDURATION

CREATE function dbo.[UFN_MKTSEGMENTPASSIVE_GETDURATION]
(
  @DURATION integer
)
returns nvarchar(100)
as
  begin
    declare @SEPARATOR nvarchar(1);
    declare @HOURS integer;
    declare @MINUTES integer;
    declare @SECONDS integer;

    -- 14 = hh:mi:ss:mmm

    set @SEPARATOR = substring(convert(nvarchar(100), getdate(), 14), 3, 1); 

    set @HOURS = @DURATION / 3600;
    set @DURATION = @DURATION - (@HOURS * 3600);
    set @MINUTES = @DURATION / 60;
    set @DURATION = @DURATION - (@MINUTES * 60);
    set @SECONDS = @DURATION;

    return convert(nvarchar, @HOURS)
           + @SEPARATOR
           + case when @MINUTES < 10 then '0' else '' end + convert(nvarchar(2), @MINUTES)
           + @SEPARATOR 
           + case when @SECONDS < 10 then '0' else '' end + convert(nvarchar(2), @SECONDS);
  end