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

7 votes170 views1 answer
Sql limit decimal places
SQL
0 vote159 views1 answer
Comparing with today and yesterday record in sql query
SQL
6 votes158 views5 answers
Sql add months to date
SQL
1 vote168 views1 answer
Oracle index partition
SQL
6 votes164 views3 answers
Mysql create database utf8
SQL
2 votes144 views1 answer
Sql server find table name
SQL
4 votes169 views2 answers
REST API
SQL
0 vote159 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote166 views1 answer
Combine 2 columns search query mysql
SQL
1 vote149 views1 answer
Update from table tsql
SQL