You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@arrow.apache.org by "David Li (Jira)" <ji...@apache.org> on 2021/08/04 12:17:00 UTC

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

David Li created ARROW-13548:
--------------------------------

             Summary: [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


Add a kernel to convert a timedelta into a number of years, months, weeks, days, hours, minutes, (micro/milli/nano)seconds, or quarters.

This should act like SQL's DATEDIFF/EXTRACT ([SQL Server|https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15], [Postgres|https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT]). Pandas doesn't have a convenient equivalent except in the case of days (pd.Timedelta.days).

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)