Building the Right Environment to Support AI, Machine Learning and Deep Learning
Watch→
SQL Server 2016 introduces the DATEDIFF_BIG function that allows you to obtain date differences between larger date ranges. DateDiff_Big returns bigint.
Here is a small example:
SELECT DATEDIFF_BIG(SECOND, '19000101', '20180403') [Big Difference]
