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
Â
⇒Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-20, 3778🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...