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 vote382 views1 answer
Min mysql
SQL
0 vote354 views1 answer
Report in database
SQL
0 vote385 views3 answers
CONTACT FORM SQL
SQL
0 vote397 views1 answer
Apt install sql server
SQL
1 vote374 views1 answer
Deleting database in sql
SQL
15 votes342 views2 answers
Install mysql 8 ubuntu 18.04
SQL
1 vote378 views1 answer
Customer using hdfc bank sql query
SQL
0 vote387 views1 answer
Google sheets data validation custom formula filter
SQL
6 votes360 views1 answer
Phpmyadmin password root
SQL
0 vote376 views1 answer
Oracle list of long running queries
SQL