[ARROW-14825] [C++] Temporal component extraction function for extracting epiyear

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 8.0.0
• Component/s: C++
• Labels: good-second-issue kernel pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/30357
• Assignee: Rok Mihevc
• Reporter: Nicola Crane
• Created: 24/Nov/21 12:37
• Updated: 11/Jan/23 08:42
• Resolved: 10/Feb/22 20:47

Description

We currently support epi_week() via the us_week kernel. Can we support epi_year() too?

epiyear in lubridate:
https://github.com/tidyverse/lubridate/blob/10731d1876f8cb902f01f8edb2810a09ce5784a4/R/accessors-year.r#L48-L69

I think this might be somewhat similar to MySQL's yearweek. It doesn't seem to be implemented universally, e.g. I don't think it's a thing in Postgres

If this isn't something desirable to implement at the C++ level, it's still possible to implement at the R level after a number of other temporal-related functions are implemented.

Issue Links

• is required by: ARROW-14824 [R] Implement bindings for lubridate::epiyear()
• links to: GitHub Pull Request #12372