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

1 vote347 views1 answer
Show all event schedular on mysql
SQL
2 votes400 views3 answers
How to replace null values in sql
SQL
0 vote371 views1 answer
Mysql db dump restore max file size issue
SQL
24 votes378 views5 answers
List mysql users
SQL
0 vote359 views2 answers
Sql update multiple tables
SQL
0 vote375 views1 answer
Best sql collation
SQL
1 vote382 views1 answer
Base64 encode sql server
SQL
2 votes331 views2 answers
Exec procedure pl sql
SQL
1 vote352 views2 answers
Mysql allow remote connections
SQL
0 vote363 views1 answer
Sql if clause within where clause
SQL