Collections:
DATEDIFF() - Calculating DATETIME Value Differences in SQL Server
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL?
✍: FYIcenter.com
If you want to calculate the difference between two date and time values, you can use the DATEDIFF() function in the following format:
DATEDIFF(datepart, startdate, enddate) returns INT: "startdate" - the start date "enddate" - the end date "datepart" - one of predefined date part names See other tutorials for the list of names
Note that SQL Server manual says DATEDIFF() returns the number of boundaries crossed by the specified part between two specified dates. This can be interpreted as truncating all parts smaller than the specified part on both input date and time values, then calculating the difference. The following tutorial exercise shows you some good DATEDIFF() usage examples:
-- Difference in days - truncating all parts -- smaller than day DECLARE @birth_date DATETIME; DECLARE @today_date DATETIME; SET @birth_date = '2000-02-29 16:10:00.000'; SET @today_date = '2000-03-02 18:30:00.000'; SELECT DATEDIFF(day, @birth_date, @today_date); GO 2 -- Difference in hours - truncating all parts -- smaller than hour DECLARE @birth_date DATETIME; DECLARE @today_date DATETIME; SET @birth_date = '2000-02-29 16:10:00.000'; SET @today_date = '2000-03-02 18:30:00.000'; SELECT DATEDIFF(hour, @birth_date, @today_date); GO 50
⇒ Calculating Age in Days, Hours and Minutes in SQL Server
⇐ DATEADD() Function Usage Examples in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-20, 3342🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...