DateDiff_BIG Function

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]
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: