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

3 votes163 views3 answers
Mysql auto increment after delete
SQL
0 vote169 views1 answer
Query to insert image
SQL
1 vote156 views1 answer
Key validation sql
SQL
1 vote179 views1 answer
Insert column after column mysql
SQL
0 vote146 views1 answer
Join in update query in mysql
SQL
0 vote179 views1 answer
Fetching data from mysqldb
SQL
6 votes143 views2 answers
Stored procedure to delete data from table in mysql
SQL
1 vote135 views1 answer
User privileges postgresql information_schema
SQL
0 vote136 views1 answer
Doesn't have default value mysql
SQL
0 vote131 views1 answer
Update set with inner join oracle
SQL