dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Jun 14th 2018 by Hannes du Preez

Language: SQL, Expertise: Beginner - See how to obtain date differences between larger date ranges in SQL Server 2016.

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]
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved