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

["David Li (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-14108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419434#comment-17419434 ] 

David Li commented on ARROW-14108:
----------------------------------

ARROW-13548 implements this for the actual month, day-time, and month-day-nano intervals. I suppose this falls under day-time except the resolution may not be fine enough?

> [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)