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

1 vote72 views1 answer
Unique vs distinct sql
SQL
0 vote116 views1 answer
ORA-13717
SQL
0 vote126 views1 answer
Mysqli last row
SQL
0 vote122 views1 answer
Hibernate xml property MySQL url, username and password
SQL
3 votes125 views1 answer
Only join in sql
SQL
2 votes127 views1 answer
While loop sql
SQL
1 vote140 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote119 views1 answer
Postgres dump sql insert
SQL
0 vote126 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote113 views1 answer
Nth max in my sql
SQL