[ARROW-13561] [C++] Implement week kernel that accepts WeekOptions

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 6.0.0
• Component/s: C++
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/29210
• Assignee: Rok Mihevc
• Reporter: Ian Cook
• Created: 04/Aug/21 18:21
• Updated: 11/Jan/23 08:33
• Resolved: 27/Sep/21 13:48

Description

Arrow has an iso_week compute kernel that follows the ISO 8601 week date definition. Add another kernel (maybe named week) that lets you specify options for how exactly to count weeks, like MySQL's week function: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_week.

I think we can reuse the existing DayOfWeekOptions to specify the options, but we should change the description of the one_based_numbering argument to:

Number from 1 if true and from 0 if false.

removing the word "days" from it, so it can control whether days or weeks are numbered starting from 0 or 1 depending on where it's used.

Issue Links

• relates to: ARROW-11759 [C++] Kernel to extract datetime components (year, month, day, etc) from timestamp type
• links to: GitHub Pull Request #11026