Sql add year to date

Sql server current date minus 5 years

SELECT GETDATE() 'Today', 
           DATEADD(day,-2,GETDATE()) 'Today - 2 Days'
SELECT GETDATE() 'Today', 
           DATEADD(dd,-2,GETDATE()) 'Today - 2 Days'
SELECT GETDATE() 'Today', 
           DATEADD(d,-2,GETDATE()) 'Today - 2 Days'

Source: sqlhints.com

Sql add year to date

//Returns Date time
//Takes where to add (as in year, month, day, etc) to
//Takes how much to add
//Takes a datetime in some different formats
DATEADD(year, 1, '2017/08/25')

Similar codes

0 vote271 views1 answer
Find how many tables in database sql query
SQL
15 votes279 views6 answers
Laravel db transaction
SQL
0 vote260 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote301 views1 answer
Sql select without column name
SQL
2 votes252 views2 answers
Change mysql password from command line
SQL
3 votes259 views2 answers
How to start postgresql on windows
SQL
0 vote248 views1 answer
Getting next sequence value jpa postgress
SQL
-2 votes282 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote250 views1 answer
Get number of tables in database sql
SQL
13 votes269 views2 answers
Sql join 3 tables
SQL