SQL Server - DATEADD() Function Usage Examples in SQL Server

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, 1833👍, 0💬

DATEDIFF() - Calculating DATETIME Value Differences in SQL Server
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL? If you want to calculate the difference between two date and time values, you can use the DATEDIFF() function in the following format: DATEDIFF(datepart, startdate, enddate) returns INT: "startdate"... 2017-02-20, 1310👍, 0💬

Calculating Age in Days, Hours and Minutes in SQL Server
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news items or blog articles are displayed with a publishing data and time represented in days, hours and minutes. To do this you can use the DATEDIFF() function with a simple algorithm as shown in the tuto... 2017-02-14, 1155👍, 0💬

Incrementing or Decrementing Parts of DATETIME Values in SQL Server
How To Increment or Decrement Parts of DATETIME Values in SQL Server Transact-SQL? If you want to increment or decrement one part of a date and time value, you can use the DATEADD() function in the following format: DATEADD(datepart, number, date) returns DATETIME: "date" - the input date "number" -... 2017-02-20, 707👍, 0💬

Date and Time Functions Supported by SQL Server 2005 in SQL Server
What Are the Date and Time Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports n character string functions: DATEADD(datepart, number, date) - Returning the same date and time value with one part added with the "number". DATEDIFF(datepart, startdate, enddate) ... 2017-02-20, 611👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.