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]

Hannes du Preez

Submit a Tip

Browse "Database Development" Tips

Browse All Tips

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.

Thanks for your registration, follow us on our social networks to keep up-to-date

WEBINAR:On-Demand

DateDiff_BIG Function

WEBINAR:

On-Demand