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 vote166 views2 answers
Sqlite unique
SQL
1 vote159 views1 answer
Firebase bigquery cloud message
SQL
0 vote197 views1 answer
Sql log file inof
SQL
0 vote175 views1 answer
Dbms_output sql developer
SQL
0 vote319 views1 answer
How to find the most occuring in SQL
SQL
0 vote193 views1 answer
Create table split string function in sql server
SQL
0 vote185 views1 answer
Can sqldatareader be null
SQL
3 votes158 views1 answer
Sql select all
SQL
0 vote167 views1 answer
Suse status MySQL
SQL
3 votes195 views1 answer
Force using index oracle
SQL