[ https://issues.apache.org/jira/browse/ARROW-14108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rok Mihevc reassigned ARROW-14108: ---------------------------------- Assignee: Rok Mihevc > [C++] interval_between(timestamptz, timestamptz) -> interval kernel > ------------------------------------------------------------------- > > Key: ARROW-14108 > URL: https://issues.apache.org/jira/browse/ARROW-14108 > Project: Apache Arrow > Issue Type: Sub-task > Components: C++ > Reporter: Weston Pace > Assignee: Rok Mihevc > Priority: Major > > 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.20.1#820001)