Ok ok, last SQL date/time post I swear. But, while testing my last entry idea, I realized you can add numbers to your date/time values. Wicked cool:
SELECT -- Query for yesterday's date. ( getDate() - 1 ) AS yesterday, -- Query for tomorrow's date. ( getDate() + 1 ) AS tomorrow
Just note that this leaves in the TIME value as-is.
Want to use code from this post? Check out the license.