[ARROW-13548] [C++] Implement datediff kernel

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 6.0.0
• Component/s: C++
• Labels: compute kernel pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/29199
• Assignee: David Li
• Reporter: David Li
• Created: 04/Aug/21 12:16
• Updated: 11/Jan/23 08:33
• Resolved: 29/Sep/21 07:50

Description

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). 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.

We have hinnant's date library vendored and this should hopefully be implementable with that.

Issue Links

• is a child of: ARROW-8894 [C++] C++ array kernels framework and execution buildout (umbrella issue)
• links to: GitHub Pull Request #10960