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 vote347 views1 answer
Postgresql powershell query
SQL
1 vote240 views1 answer
How to remove identity from a column in sql server
SQL
0 vote210 views1 answer
Mysql workbench search all tables
SQL
10 votes236 views1 answer
Oracle object dependencies
SQL
0 vote235 views1 answer
Ms sql database data size
SQL
10 votes190 views1 answer
Oracle view dependencies
SQL
0 vote242 views1 answer
Mysql Like(searching in the string)
SQL
0 vote224 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote253 views1 answer
PGSQL dynamic table name
SQL
0 vote251 views1 answer
Python connect to mysql in settings.py
SQL