Collections:
Incrementing or Decrementing Parts of DATETIME Values in SQL Server
How To Increment or Decrement Parts of DATETIME Values in SQL Server Transact-SQL?
✍: FYIcenter.com
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
2017-02-20, 2395🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...