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 vote323 views1 answer
Mysql sql select one day before
SQL
0 vote352 views1 answer
Sqlite woth cmake
SQL
8 votes319 views1 answer
Oracle search source code
SQL
1 vote340 views1 answer
Postgresql define pk sequence next number
SQL
1 vote336 views1 answer
Mysql check if string contains comma separated
SQL
1 vote324 views1 answer
Sql delete row with auto increment
SQL
1 vote345 views3 answers
How to update column name in psql
SQL
0 vote311 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote382 views1 answer
Mysql dump for selected row
SQL
1 vote383 views1 answer
Postgresql where datetrunc month and year equal
SQL