[ARROW-14006] [C++][Python] Support cast of naive timestamps to strings

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.0.0
• Fix Version/s: 6.0.0
• Component/s: C++, Python
• Labels: kernel types
• External issue URL: https://github.com/apache/arrow/issues/29606
• Assignee: Unassigned
• Reporter: Jorge Leitão
• Created: 15/Sep/21 16:42
• Updated: 11/Jan/23 08:36
• Resolved: 29/Aug/22 14:14

Description

When writing to CSV, timestamp columns error with cast_string not supporting timestamp[ns]. It would be nice to support this cast this via e.g. ISO 8601.

This happened when trying to use postgres' COPY ... FROM STDIN WITH CSV, which is a method to bulk load data into postgres.