Collections:
DATEADD() Function Usage Examples in SQL Server
How To Use DATEADD() Function in SQL Server Transact-SQL?
✍: FYIcenter.com
DATEADD() is a very useful function for manipulating date and time values. The following tutorial exercise shows you some good DATEADD() usage examples:
-- Incrementing 1 year on a leap date DECLARE @birth_date DATETIME; SET @birth_date = '2000-02-29 16:00:00.000'; SET @birth_date = DATEADD(year, 1, @birth_date); SELECT @birth_date; GO 2001-02-28 16:00:00.000 -- Decrementing 1 month on a leap date DECLARE @birth_date DATETIME; SET @birth_date = '2000-02-29 16:00:00.000'; SET @birth_date = DATEADD(month, -1, @birth_date); SELECT @birth_date; GO 2000-01-29 16:00:00.000 -- Incrementing 2 milliseconds DECLARE @birth_date DATETIME; SET @birth_date = '2000-02-29 16:00:00.000'; SET @birth_date = DATEADD(millisecond, 2, @birth_date); SELECT @birth_date; GO 2000-02-29 16:00:00.003
⇒ DATEDIFF() - Calculating DATETIME Value Differences in SQL Server
⇐ Incrementing or Decrementing Parts of DATETIME Values in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-20, 3926🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...