[jira] [Created] (ARROW-14108) [C++] interval_between(timestamptz, timestamptz) -> interval kernel

["Weston Pace (Jira)" <ji...@apache.org>]

Weston Pace created ARROW-14108:
-----------------------------------

             Summary: [C++] interval_between(timestamptz, timestamptz) -> interval kernel
                 Key: ARROW-14108
                 URL: https://issues.apache.org/jira/browse/ARROW-14108
             Project: Apache Arrow
          Issue Type: Improvement
            Reporter: Weston Pace


Given two timestamps that each have time zones this function should return an interval from the first timestamp to the second timestamp according to the following rules (postgres rules):

* 1 day is 24 physical hours (which may not exactly equal 1 calendar day).
* Intervals returned will never contain a months/years field

Examples:

interval_between('2021-03-14 00:00:00 America/Denver', '2021-03-15 00:00:00 America/Denver') => { "hours": 23 }
interval_between('2021-03-14 00:00:00 UTC', '2021-03-15 00:00:00 UTC') => { "days": 1}
interval_between('2021-03-14 00:00:00 UTC', '2020-03-14 00:00:00 UTC') => { "days": 365}

If the first timestamp is larger than the second timestamp then the interval will be negative.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)