[
https://issues.apache.org/jira/browse/ARROW-13548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Li updated ARROW-13548:
-----------------------------
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|https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15]).
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|https://stackoverflow.com/questions/54171674/calculating-the-amount-of-full-months-between-two-dates].
We have hinnant's date library vendored and this should hopefully be
implementable with that.
was:
Add a kernel to convert a timedelta into a number of years, months, weeks,
days, hours, minutes, (micro/milli/nano)seconds, or quarters.
This should act like SQL's DATEDIFF/EXTRACT ([SQL
Server|https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15],
[Postgres|https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT]).
Pandas doesn't have a convenient equivalent except in the case of days
(pd.Timedelta.days).
We have hinnant's date library vendored and this should hopefully be
implementable with that.
> [C++] Implement datediff kernel
> -------------------------------
>
> Key: ARROW-13548
> URL: https://issues.apache.org/jira/browse/ARROW-13548
> Project: Apache Arrow
> Issue Type: Improvement
> Components: C++
> Reporter: David Li
> Priority: Major
> Labels: compute
>
> 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|https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15]).
> 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|https://stackoverflow.com/questions/54171674/calculating-the-amount-of-full-months-between-two-dates].
> We have hinnant's date library vendored and this should hopefully be
> implementable with that.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
