[jira] [Commented] (ARROW-11090) [C++] Support temporal arithmetic ({time,date}{32,64}, timestamp, duration)

["Phillip Cloud (Jira)" <ji...@apache.org>]

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

Phillip Cloud commented on ARROW-11090:
---------------------------------------

Broadly speaking, I we should adopt the behavior of PostgreSQL here with respect to the operations that are at first glance ambiguous, such as

{code:sql}
SELECT DATE '2021-05-31' + INTERVAL '1' MONTH
{code}

This behavior appears to be described at least partially in https://www.postgresql.org/docs/current/functions-datetime.html after the section on the {{OVERLAPS}} operator.

> [C++] Support temporal arithmetic ({time,date}{32,64}, timestamp, duration)
> ---------------------------------------------------------------------------
>
>                 Key: ARROW-11090
>                 URL: https://issues.apache.org/jira/browse/ARROW-11090
>             Project: Apache Arrow
>          Issue Type: New Feature
>          Components: C++
>            Reporter: Jonathan Keane
>            Priority: Major
>              Labels: kernel
>             Fix For: 7.0.0
>
>
> [It appears that only subtract on two timestamps is currently supported|https://github.com/apache/arrow/commit/dd94a5809b56b32fe2fb538f688bf568d9642e3b] when there is more supported, we should include support for that in R.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)