[ARROW-14947] [C++] Implement maths with timestamps

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: C++
• External issue URL: https://github.com/apache/arrow/issues/30469
• Assignee: Unassigned
• Reporter: Nicola Crane
• Created: 01/Dec/21 16:36
• Updated: 11/Jan/23 08:43
• Resolved: 01/Mar/22 11:40

Description

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

Issue Links

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