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 vote180 views1 answer
Sql compound operators
SQL
2 votes183 views2 answers
Postgres set user as superuser
SQL
0 vote200 views2 answers
How to get the date from datetime in mysql
SQL
1 vote208 views1 answer
Postgresql create table with timestamp
SQL
0 vote203 views1 answer
Kill mysqld_safe process mariadb
SQL
1 vote180 views1 answer
Oracle sql create or replace view
SQL
1 vote177 views1 answer
Update from select join
SQL
0 vote193 views1 answer
Java input type sql date
SQL
3 votes212 views2 answers
Order by postgresql
SQL
1 vote222 views1 answer
Mysql last year
SQL