How to find timespan in milliseconds between two times?

datetime, sql, sql-server, t-sql, timespan

Solution

Using the datediff function as documented here.

declare @start datetime = '2012-04-10 14:59:12.863',     
    @end datetime = '2012-04-10 14:59:13.800'     

select datediff(ms, @start, @end)

The ms is the datepart abbreviation for milliseconds.

Problem

Using TSQL how do you find the difference between two times, in milliseconds? ``` declare @start datetime = '2012-04-10 14:59:12.863', @end datetime = '2012-04-10 14:59:13.800' select @start, @end, 'TODO: get timespan in milliseconds between @start and @end' ```

Original source