You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jira@arrow.apache.org by "Weston Pace (Jira)" <ji...@apache.org> on 2021/09/23 12:44:00 UTC

[jira] [Comment Edited] (ARROW-14098) [C++] subtract(time, time) -> duration kernel

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

Weston Pace edited comment on ARROW-14098 at 9/23/21, 12:43 PM:
----------------------------------------------------------------

There are a fair number of differences between this and DATEDIFF.  DATEDIFF returns the number of boundaries crossed.  For example, DATEDIFF(00:00:00, 23:59:59, HOURS) would yield "1" and this kernel yields 1 second.

Other than the semantic meaning:

DATEDIFF returns an integer, this returns a duration
DATEDIFF requires taking the time zone into account for timestamps with time zones, this kernel would not.


was (Author: westonpace):
There are a fair number of differences between this and DATEDIFF.  DATEDIFF returns the number of boundaries crossed.  For example, DATEDIFF(2021-01-02T00:00:00, 2021-01-01T23:59:59, DAYS) would yield "1" and this kernel yields 1 second.

Other than the semantic meaning:

DATEDIFF returns an integer, this returns a duration
DATEDIFF requires taking the time zone into account for timestamps with time zones, this kernel would not.

> [C++] subtract(time, time) -> duration kernel
> ---------------------------------------------
>
>                 Key: ARROW-14098
>                 URL: https://issues.apache.org/jira/browse/ARROW-14098
>             Project: Apache Arrow
>          Issue Type: Sub-task
>          Components: C++
>            Reporter: Phillip Cloud
>            Priority: Major
>
> Issue to track subtraction of times.



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