DATEADD to change datetimes in SQL Server

[lauweded]

Basic syntax

DATEADD(<Unit of time>, <Units>, <Date>)

-- Add 5 days to 04/23/2021
DATEADD(DAY, 5, '2021-04-23')

-- Substract 5 days to 04/23/2021
DATEADD(MONTH, -5, '2021-04-23')

Units of time

Unit of time	Abbreviation
NANOSECOND	ns
MICROSECOND	mcs
MILLISECOND	ms
SECOND	ss, s
MINUTE	mi, n
HOUR	hh
WEEKDAY	dw, w
WEEK	wk, ww
DAY	dd, d
DAYOFYEAR	dy, d
MONTH	mm, m
QUARTER	qq, q
YEAR	yy, yyyy

More information

To get more info on the Docs

Comments

[hivebuzz]

Congratulations @lauweded! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :

You received more than 50 HP as payout for your posts and comments. Your next payout target is 100 HP. The unit is Hive Power equivalent because your rewards can be split into HP and HBD

_{You can view your badges on your board and compare yourself to others in the Ranking
If you no longer want to receive notifications, reply to this comment with the word STOP}

Check out the last post from @hivebuzz:

	False-Positive phishing alert reported by antivirus software
	Feedback from the May 1st Hive Power Up Day

Support the HiveBuzz project. Vote for our proposal!