DATEDIFF_BIG Function in SQL Server

This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value).

The operation or conduct is identical to the DATEDIFF function. The only distinction is that although DATEDIFF BIG() returns a signed big integer, DATEDIFF() returns a signed integer (INT) (BIGINT).

Examples:

Hope you find this post helpful.