Last time we looked at adding or subtracting date parts using the DATEADD() T-SQL system function. This week we see how to calculate the difference between two date-time values using DATEDIFF() and DATEDIFF_BIG(). The syntax for both functions is identical: [crayon-5c98bf6b32fe2735177395/] The only functional difference between them is that the DATEDIFF_BIG() returns values as a
-> Continue reading Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG()

The post Dates and Times in SQL Server: DATEDIFF() and DATEDIFF_BIG() appeared first on Born SQL.