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)
