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, 3932🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...