DATEADD() Function Usage Examples in SQL Server

Q

How To Use DATEADD() Function in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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

⇒⇒SQL Server Transact-SQL Tutorials

2017-02-20, 260👍, 0💬