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 vote193 views1 answer
Postgres enumerated type
SQL
0 vote250 views1 answer
Check database restore status sql script
SQL
0 vote208 views1 answer
Sql count more than 1
SQL
2 votes194 views1 answer
Sql column values comma separated
SQL
3 votes207 views2 answers
Create schema postgres
SQL
0 vote216 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
0 vote188 views2 answers
Find Overlapping sql
SQL
0 vote232 views1 answer
Sql server beginning of month
SQL
1 vote255 views1 answer
Varchar plsql
SQL
0 vote211 views1 answer
Grant owner postgresql
SQL