Collections:
Adding and Removing Days on Date and Time Values in SQL Server
How To Add or Remove Days on Date and Time Values in SQL Server Transact-SQL?
✍: FYIcenter.com
SQL Server 2005 only support two operators on data and time values:
Note that to add or subtract days on a date and time value, the other operand must be a numeric value: an integer or a decimal number.
Here are some good examples of adding days to and subtracting days from date and time values:
-- Leap year is supported DECLARE @birth_date DATETIME; SET @birth_date = '29-Feb-2000 03:00:00.000'; SELECT @birth_date + 1; SELECT @birth_date - 1; GO 2000-03-01 03:00:00.000 2000-02-28 03:00:00.000 -- Partial days are supported DECLARE @birth_date DATETIME; SET @birth_date = '29-Feb-2000 03:00:00.000'; SELECT @birth_date + 0.5; -- adding a half day SELECT @birth_date + 1.0/3; GO 2000-03-01 15:00:00.000 2000-02-29 10:59:59.970
⇒ Converting Date and Time Values into Integers in SQL Server
⇐ Verify Time Precision in SQL Server Transact-SQL
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-22, 3503🔥, 0💬
Popular Posts:
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...