It appears that only subtract on two timestamps is currently supported when there is more supported, we should include support for that in R.

This should also cover the ability to do with and without rollback (so have the ability to do e.g. 2021-03-30 minus 1 month and either get a null back, or 2021-02-28), plus the ability to specify whether to rollback to the first or last, and whether to preserve or rest the time.)

Reporter: Jonathan Keane / @jonkeane
Watchers: Rok Mihevc / @rok

Subtasks:

• [C++] add(date, duration) -> timestamp kernel
• [C++] subtract(date, duration) -> timestamp kernel
• [C++] subtract(date, date) -> duration kernel
• [C++] add(timestamp, duration) -> timestamp kernel
• [C++] subtract(timestamp, duration) -> timestamp kernel
• [C++] add(time, duration) -> time kernel
• [C++] subtract(time, duration) -> time kernel
• [C++] subtract(time, time) -> duration kernel
• [C++] add(duration, duration) -> duration kernel
• [C++] subtract(duration, duration) -> duration kernel
• [C++] multiply(duration, integer) -> duration kernel
• [C++] divide(duration, integer) -> duration kernel
• [C++] interval_between(timestamptz, timestamptz) -> struct kernel
• [C++] Support rolling backwards and forwards with temporal arithmetic
• [C++] Add_kernel not commutative (timestamps & duration maths)
• [C++] temporal addition and subtraction with integers

Related issues:

• [C++] C++ array kernels framework and execution buildout (umbrella issue) (is a child of)
• [C++] Implement maths with timestamps (is duplicated by)
• [C++] Add_kernel not commutative (timestamps & duration maths) (is related to)
• [R] Implement lubridate's %m+%, %m-%, add_with_rollback, and addition and subtraction with timestamp (is depended upon by)
• [R] Update as.Date() to support an origin different from epoch (is depended upon by)
• [R] Implement lubridate functions for doing maths with dates (is depended upon by)

_{Note: This issue was originally created as ARROW-11090. Please see the migration documentation for further details.}