[C++] Implement maths with timestamps

[asfimport]

Please could we have maths with timestamps implemented?

In order to implement some of the functionality I'd like in R, I need to be able to do maths with dates. For example:

• Addition and subtraction: Timestamp + Duration = Timestamp (with and without rollback so have 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.

  See https://lubridate.tidyverse.org/reference/mplus.html for documentation of the R functionality.

• Multiplying Durations: Duration * Numeric = Duration

Reporter: Nicola Crane / @thisisnic
Watchers: Rok Mihevc / @rok

Related issues:

• [C++] Support temporal arithmetic ({time,date}{32,64}, timestamp, interval) (duplicates)
• [R] Implement lubridate's %m+%, %m-%, add_with_rollback, and addition and subtraction with timestamp (is depended upon by)

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

[asfimport]

Rok Mihevc / @rok:
Is this covered by ARROW-11090 ?

[asfimport]

Nicola Crane / @thisisnic:
@rok - you are right, I will close this one as a duplicate

[asfimport]

Rok Mihevc / @rok:
@thisisnic sorry this wasn't a really duplicate as it covers the R side of things. ARROW-11090 is mostly done so perhaps we should reopen this?

[asfimport]

Dragoș Moldovan-Grünfeld / @dragosmg:
@rok  happy to reopen this.

[asfimport]

Rok Mihevc / @rok:
@dragosmg you probably know better than me, but I'd say go for it.

[asfimport]

Dragoș Moldovan-Grünfeld / @dragosmg:
@rok I haven't looked much into this. Do you think it's still a C++ component issue? 

[asfimport]

Rok Mihevc / @rok:
@dragosmg I didn't look into how rollback works, but I'm guessing it's kind of like add/sub/mul/div followed by a floor or ceil? If that is the case you could just use the add/sub/muldiv kernels from ARROW-11090 and add floor/ceil for rollback cases. In case there is something still missing in C++ we should identify it and write Jiras.

[asfimport]

Nicola Crane / @thisisnic:
@rok I haven't looked into it in-depth but I think this is still a duplicate. May as well open a fresh R ticket if needed, if there's anything beyond the scope of ARROW-14948 to implement here.

[asfimport]

Rok Mihevc / @rok:
Ok, that's good then. Please close this one.