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

["Joris Van den Bossche (Jira)" <ji...@apache.org>]

Joris Van den Bossche created ARROW-11759:
---------------------------------------------

             Summary: [C++] Kernel to extract datetime components (year, month, day, etc) from timestamp type
                 Key: ARROW-11759
                 URL: https://issues.apache.org/jira/browse/ARROW-11759
             Project: Apache Arrow
          Issue Type: Improvement
          Components: C++
            Reporter: Joris Van den Bossche


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:

{code}
>>> 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
{code}

(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:

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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)