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
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-22, 808👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...