Collections:
Subtracting a DATETIME Value from Another DATETIME Value in SQL Server
Can a DATETIME Value Be Subtracted from Another DATETIME Value in SQL Server Transact-SQL?
✍: FYIcenter.com
Can a datetime value be subtracted from another datetime value? The answer is yes. The subtract operation can be performed by the subtract operator (-) as:
The tutorial exercise below shows you some good examples:
DECLARE @birth_date DATETIME; DECLARE @today_date DATETIME; SET @birth_date = '2000-02-29 16:00:00.000'; SET @today_date = '2007-05-19 22:00:00.000'; SELECT @today_date - @birth_date; GO 1907-03-22 06:00:00.000 DECLARE @birth_date DATETIME; DECLARE @today_date DATETIME; DECLARE @age NUMERIC(9,2); SET @birth_date = '2000-02-29 16:00:00.000'; SET @today_date = '2007-05-19 22:00:00.000'; SET @age = CONVERT(NUMERIC(9,2), @today_date - @birth_date); SELECT @age; GO 2636.25
⇒ Date and Time Functions Supported by SQL Server 2005 in SQL Server
⇐ Converting DATETIME and NUMERIC Values in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-20, 1256🔥, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...