• DECLARE @ms AS INTEGER

    SELECT @ms = 86399998

    SELECT CONVERT (CHAR(13), DATEADD (ms, @ms, '01/01/00'), 14)

    Obviously this would be the maximum number that it would show after this you would need to handle days - Remember that milliseconds are displayed and rounded to 1/300 of a second