[ARROW-11759] [C++] Kernel to extract datetime components (year, month, day, etc) from timestamp type

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 5.0.0
• Component/s: C++
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/27613
• Assignee: Rok Mihevc
• Reporter: Joris Van den Bossche
• Created: 24/Feb/21 09:54
• Updated: 11/Jan/23 08:21
• Resolved: 09/Jun/21 17:28

Description

It can be very useful to extract certain "fields" from the timestamp, such as the year, month, day, etc.

See eg https://pandas.pydata.org/docs/user_guide/timeseries.html#time-date-components for the ones available in pandas.

Using pandas as an example, there are the basic components of the datetime:

>>> ts = pd.Timestamp.now()
>>> ts
Timestamp('2021-02-24 10:47:54.294504')

>>> ts.year
2021
>>> ts.month
2
>>> ts.day
24
>>> ts.hour
10
>>> ts.minute
49
>>> ts.second
54
>>> ts.microsecond
607393
>>> ts.nanosecond
0

(only for the sub-second, this is not fully clear how to divide it in microseconds or milliseconds, etc)

But in addition also some more "advanced" like:

>>> ts.dayofyear
55
>>> ts.dayofweek
2
>>> ts.week
8
>>> ts.isocalendar()
(2021, 8, 3)

Issue Links

• is depended upon by: ARROW-13022 [R] bindings for lubridate's year, isoyear, quarter, month, day, wday, yday, isoweek, hour, minute, and second functions
• is depended upon by: ARROW-12844 [R] Implement common date and time functions for dplyr
• is related to: ARROW-13561 [C++] Implement week kernel that accepts WeekOptions
• links to: GitHub Pull Request #10176