dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

Creating a Secure Socket
Tip: Creating a Secure Socket
Tip: Replace a Web API Response with a Custom JSON
Tip: Employing DBCC PINTABLE and DBCC UNPINTABLE Functions
Replace a Web API Response with a Custom JSON

Tip of the Day
Language: SQL
Expertise: Beginner
Jun 14, 2018

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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
Thanks for your registration, follow us on our social networks to keep up-to-date