[ARROW-9525] [Python] Array.__str__ shows misleading output for timestamp types with time zone set

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: C++, Python
• Labels: timezone
• External issue URL: https://github.com/apache/arrow/issues/25593
• Assignee: Unassigned
• Reporter: Wes McKinney
• Created: 19/Jul/20 22:56
• Updated: 11/Jan/23 08:07

Description

The output is being shown with UTC interpretation

In [13]: arr = pa.array([0, 1, 2], type=pa.timestamp('ns', 'America/Los_Angeles'))             

In [14]: arr.view('int64')                                                                     
Out[14]: 
<pyarrow.lib.Int64Array object at 0x7fd1b8acdd70>
[
  0,
  1,
  2
]

In [15]: arr.type                                                                              
Out[15]: TimestampType(timestamp[ns, tz=America/Los_Angeles])

In [16]: arr                                                                                   
Out[16]: 
<pyarrow.lib.TimestampArray object at 0x7fd1b8ad5ec0>
[
  1970-01-01 00:00:00.000000000,
  1970-01-01 00:00:00.000000001,
  1970-01-01 00:00:00.000000002
]