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

[jira] [Resolved] (ARROW-13548) [C++] Implement datediff kernel

     [ https://issues.apache.org/jira/browse/ARROW-13548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Antoine Pitrou resolved ARROW-13548.
------------------------------------
    Resolution: Fixed

Issue resolved by pull request 10960
[https://github.com/apache/arrow/pull/10960]

> [C++] Implement datediff kernel
> -------------------------------
>
>                 Key: ARROW-13548
>                 URL: https://issues.apache.org/jira/browse/ARROW-13548
>             Project: Apache Arrow
>          Issue Type: Improvement
>          Components: C++
>            Reporter: David Li
>            Assignee: David Li
>            Priority: Major
>              Labels: compute, kernel, pull-request-available
>             Fix For: 6.0.0
>
>          Time Spent: 8h 50m
>  Remaining Estimate: 0h
>
> Add a kernel to compute the number of years, months, weeks, days, hours, minutes, (micro/milli/nano)seconds, or quarters between two timestamps. 
> This should act like SQL's DATEDIFF ([SQL Server|https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15]). Pandas doesn't have a convenient equivalent except in the case of days (pd.Timedelta.days) but it can be [calculated using Timestamp.to_period|https://stackoverflow.com/questions/54171674/calculating-the-amount-of-full-months-between-two-dates].
> We have hinnant's date library vendored and this should hopefully be implementable with that.



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