Incrementing or Decrementing Parts of DATETIME Values in SQL Server

Q

How To Increment or Decrement Parts of DATETIME Values in SQL Server Transact-SQL?

✍: FYIcenter.com

A

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" - the incrementing amount
"datepart" - one of predefined date part names

Valid date part names are:

year, yy, yyyy - The year part
quarter, qq, q - The quarter part
month, mm, m - The month part
dayofyear, dy, y - The day-of-year part
day, dd, d - The day part
week, wk, ww - The week part
weekday, dw, w - The weekday part 
hour, hh - The hour part
minute, mi, n - The minute part
second, ss, s - The second part
millisecond, ms - The millisecond part

For example, DATEADD(year, 1, @birth_date) will increment 1 year to @birth_date.

 

DATEADD() Function Usage Examples in SQL Server

Date and Time Functions Supported by SQL Server 2005 in SQL Server

Date/Time Operations and Functions in SQL Server Transact-SQL

⇑⇑ SQL Server Transact-SQL Tutorials

2017-02-20, 2062🔥, 0💬