Post
Ask Question

SQL Server Transact Basic to Expert - Incrementing a date value (Year) using query

This blog shows how to do an year increment in the output using SQL Query

Example:

SELECT DATEADD(yy, -1, '2/2/2010')

The expected result would be 2011-02-02 00:00:00.000
Next Recommended Reading SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query