As shown in this QOTD, adding/subtracting a number from a date is adding/subtracting that many whole days.

Is this standard behavior, or is this undocumented behavior that could change in the future (to minutes/weeks/whatever)?

I've wondered about this before, and so have always stuck with using DATEADD to be sure my code is safe.