Posts Elapsed Time Calculation on SQL Server with dateDiff
Post
Cancel

Elapsed Time Calculation on SQL Server with dateDiff

1
2
3
4
5
6
7
8
9
10
11
12
//https://stackoverflow.com/questions/4073340/using-datediff-to-find-duration-in-minutes

DECLARE @t1 DATETIME='2020-11-11 11:28:35'
DECLARE @t2 DATETIME=  GETDATE()
print  CAST(dateDiff(second,@t1,@t2) as INT)

/*
possible values
second
minute
millisecond
*/

origin - https://www.pipiscrew.com/?p=19365 elapsed-time-calculation-on-sql-server-with-datediff

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags