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 vote133 views2 answers
Sql queries practice
SQL
0 vote117 views9 answers
Linq to sql converter online
SQL
0 vote108 views1 answer
Create new table pl sql
SQL
6 votes123 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
2 votes132 views2 answers
How to check data type in sql server
SQL
1 vote126 views2 answers
Logical operators in sql
SQL
0 vote117 views1 answer
Alasql delete column
SQL
5 votes114 views2 answers
Get number of columns sql
SQL
0 vote130 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote108 views1 answer
Show specific events on mysql
SQL