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

1 vote93 views1 answer
Oracle boolean to varchar
SQL
0 vote152 views1 answer
Sqlalchemy query join many to many
SQL
0 vote129 views1 answer
Min:sec datediff mssql
SQL
22 votes159 views3 answers
Sql cheat sheet
SQL
0 vote135 views1 answer
Sintaxis SELECT sql
SQL
0 vote138 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote130 views1 answer
Oracle job class
SQL
0 vote140 views1 answer
Mysql date time string format for marshmellow field schema
SQL
1 vote159 views1 answer
Backup mysql schema only
SQL
0 vote126 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL