[ARROW-13549] [C++] Implement timestamp to date/time cast that extracts value

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 6.0.0
• Component/s: C++
• Labels: kernel pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/29200
• Assignee: David Li
• Reporter: David Li
• Created: 04/Aug/21 12:25
• Updated: 11/Jan/23 08:33
• Resolved: 27/Sep/21 14:44

Description

Change casting from timestamp to date/time to extract the value, instead of just truncating as we currently do (which rounds, giving incorrect answers, in some cases). This should also be a safe cast by default (unless you want to do something like cast from timestamp[ns] to time32[s] which may overflow).

This should behave like Postgres DATE/CAST(... as TIME), or Pandas Timestamp.date/Timestamp.time.

Issue Links

• is a child of: ARROW-8894 [C++] C++ array kernels framework and execution buildout (umbrella issue)
• is duplicated by: ARROW-10213 [C++] Temporal cast from timestamp to date rounds instead of extracting date component
• links to: GitHub Pull Request #10933