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

31 votes188 views2 answers
Grant all priviledges to mysql user
SQL
1 vote189 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote162 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote192 views1 answer
Postgresql auto increment not working
SQL
1 vote171 views1 answer
Loading local data is disabled mysql
SQL
16 votes179 views3 answers
Tsql rename column name
SQL
0 vote199 views1 answer
Oracle webcenter content search enginer
SQL
19 votes203 views6 answers
Create table sqlite
SQL
0 vote185 views1 answer
Watch mysql command line
SQL
0 vote184 views2 answers
Execute stored procedure without db set
SQL