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

Tip: Operations on Dates and Times
Operations on Dates and Times
Explore More Methods in the java.lang.Math Package
Tip: Explore More Methods in the java.lang.Math Package
Tip: Working with the IIF Statement in T-SQL

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
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

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