By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.



advertisement

 

See how to obtain date differences between larger date ranges in SQL Server 2016.

advertisement

Application Security Testing: An Integral Part of DevOps

SQL Server 2016 introduces the DATEDIFF_BIG 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]

 

Visit the DevX Tip Bank

 

Please enable Javascript in your browser, before you post the comment! Now Javascript is disabled.

Comment and Contribute

 

 



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here