[ https://issues.apache.org/jira/browse/ARROW-14108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419435#comment-17419435 ]
David Li commented on ARROW-14108: ---------------------------------- Oh, on a closer reading, this is different, given the days are not calendar days. > [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 > Reporter: Weston Pace > 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.3.4#803005)