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 votes212 views1 answer
Oracle detect invalid password
SQL
0 vote242 views1 answer
How to install postgresql on wsl
SQL
0 vote234 views1 answer
Mysql regex select
SQL
6 votes228 views1 answer
Phpmyadmin password root
SQL
2 votes291 views5 answers
Tablespace ORACLE
SQL
0 vote237 views1 answer
Isnull in sqlite
SQL
15 votes232 views3 answers
Find duplicate keys in mysql
SQL
0 vote230 views1 answer
Authentication in sql server
SQL
0 vote226 views3 answers
Average salary in sql
SQL
0 vote238 views1 answer
Create table as select sql server error
SQL