• declare @milli as int

    set @milli = 11202079

    select @milli/3600000 as hours,

    (@milli - ((@milli/3600000)*3600000))/60000 as minutes,

    (@milli - (((@milli)/60000)*60000)) /1000 as seconds,

    @milli-(((@milli)/1000)*1000) as milliseconds