By submitting your information, you agree that 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.



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


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


Please enter your comment!
Please enter your name here