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 vote298 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote270 views1 answer
Distinct data types in a table sql query
SQL
0 vote282 views1 answer
Sql select sum group by id laravel join
SQL
-2 votes276 views2 answers
Union vs union all in sql
SQL
1 vote270 views1 answer
Launch sql script from docker in mysql
SQL
0 vote267 views1 answer
Tsql find procedure with name
SQL
2 votes267 views1 answer
Oracle apex who is connected
SQL
0 vote295 views1 answer
See the structure of a table mysql
SQL
10 votes219 views1 answer
Oracle view dependencies
SQL
2 votes256 views1 answer
Oracle log files
SQL