OK, so, strictly speaking not a bug, but certainly an infelicity. Maybe someone can step on it next time something else needs fixing in DATETIME_DIFF…

For background, see this post in the Support forum.

Specifying 'day ' or 'days ' rather than 'day' or 'days' produces wildly incorrect results:

Thanks!