Home Forums SQL Server 2005 T-SQL (SS2K5) Convert DateDiff into Hours, Minutes, Seconds, Milliseconds RE: Convert DateDiff into Hours, Minutes, Seconds, Milliseconds

  • [font="Courier New"][/font]DECLARE @BatchStart datetime = GETDATE(), @StageStart datetime, @Iteration int = 0, @Iterations int = 5

    PRINT 'Batch start: ' + CONVERT(varchar(12), DATEADD(ms, DATEDIFF(ms, @BatchStart, @BatchStart), 0), 114)

    WHILE @Iteration <> @Iterations BEGIN

    SELECT @Iteration = @Iteration + 1, @StageStart = GETDATE()

    WAITFOR DELAY '00:00:01'

    PRINT ' Iteration ' + CAST(@Iteration as varchar(3)) + ': ' + CONVERT(varchar(12), DATEADD(ms, DATEDIFF(ms, @StageStart, GETDATE()), 0), 114)

    END

    PRINT 'Batch time : ' + CONVERT(varchar(12), DATEADD(ms, DATEDIFF(ms, @BatchStart, GETDATE()), 0), 114)

    Good for 24h, but can easily be adjusted for more.