>> SQL Server also has +/- for datetime, although I suspect this is due to implicit conversion. <<

The ANSI/ISO version has to have temporal units with the +/- like
this:

(my_date + INTERVAL 2 DAYS)

This makes more sense and avoids the rubbish.