[
https://issues.apache.org/jira/browse/ARROW-14122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419918#comment-17419918
]
Weston Pace edited comment on ARROW-14122 at 9/24/21, 6:19 PM:
---------------------------------------------------------------
This has come up in ML discussions and comparing intervals is a difficult topic
because "1 day" is sometimes "23 hours, 24 hours, and 25 hours" and "1 month"
is sometimes "28/29/30/31 days" and "1 year" is either "360 days, 365 days, or
365.25 days" and even the 365 day crowd will admit it is sometimes 364 days.
That being said, for simplicity, I would like to see a comparison scheme for
intervals simply because every other simple type is comparable. I'd like to
propose the postgres ordering which can be summed up as:
{noformat}
1 day = 24 hours
1 month = 30 days
1 year = 12 months (and thus, transitively, 360 days)
{noformat}
was (Author: westonpace):
This has come up in ML discussions and comparing intervals is a difficult topic
because "1 day" is sometimes "23 hours, 24 hours, and 25 hours" and "1 month"
is sometimes "28/29/30/31 days" and "1 year" is either "360 days, 365 days, or
365.25 days" and even the 365 day crowd will admit it is sometimes 364 days.
That being said, for simplicity, I would like to see a comparison scheme for
intervals simply because every other simple type is comparable. I'd like to
propose the postgres ordering which can be summed up as:
```
1 day = 24 hours
1 month = 30 days
1 year = 12 months (and thus, transitively, 360 days)
```
> [C++] interval comparison kernels
> ---------------------------------
>
> Key: ARROW-14122
> URL: https://issues.apache.org/jira/browse/ARROW-14122
> Project: Apache Arrow
> Issue Type: Sub-task
> Reporter: Phillip Cloud
> Priority: Major
> Labels: kernel
>
> Subtask for tracking interval comparison kernels
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
