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

15 votes105 views4 answers
How to get all tables in sql
SQL
0 vote103 views1 answer
Pagination with row_number
SQL
0 vote110 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote107 views1 answer
How to find columns with null values in sql
SQL
0 vote96 views1 answer
Get records in sql according to month name and count
SQL
0 vote97 views1 answer
How to count null values in sql
SQL
1 vote109 views1 answer
Rails run native ssql query
SQL
0 vote102 views1 answer
Change permission to database mysql
SQL
0 vote99 views1 answer
Openquery insert into linked server
SQL
18 votes103 views4 answers
Mysql current date between two dates
SQL