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 vote163 views2 answers
Oracle chain rules
SQL
1 vote176 views2 answers
Create a unqie constraint mysql
SQL
0 vote112 views1 answer
Sql truncate table referencing itself
SQL
0 vote151 views1 answer
Monthly Birthday SQL Query
SQL
11 votes166 views2 answers
Safe mode off mysql
SQL
5 votes149 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote148 views2 answers
Insert into
SQL
1 vote154 views1 answer
Postgres grant read only access to database
SQL
0 vote166 views1 answer
Mysql select where field is a value
SQL
0 vote157 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL