Adding Numbers To Date/Time Values 

SELECT
	-- Query for yesterday's date.
	(
		getDate() - 1
	) AS yesterday,
	 
	-- Query for tomorrow's date.
	(
		getDate() + 1
	) AS tomorrow

For Cut-and-Paste