[ARROW-13896] [Python] Print of timestamp with timezone errors

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 7.0.0
• Component/s: Python
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/29511
• Assignee: Alenka Frim
• Reporter: Jorge Leitão
• Created: 03/Sep/21 18:53
• Updated: 11/Jan/23 08:36
• Resolved: 04/Nov/21 10:42

Description

import pyarrow as pa

a = pa.array([0], pa.timestamp('s', tz='+02:00'))

print(a) # representation not correct?
# <pyarrow.lib.TimestampArray object at 0x7f834c7cb9a8>
# [
#  1970-01-01 00:00:00
# ]

print(a[0])
#Traceback (most recent call last):
#  File "<stdin>", line 1, in <module>
#  File "pyarrow/scalar.pxi", line 80, in pyarrow.lib.Scalar.__repr__
#  File "pyarrow/scalar.pxi", line 463, in pyarrow.lib.TimestampScalar.as_py
#  File "pyarrow/scalar.pxi", line 393, in pyarrow.lib._datetime_from_int
#ValueError: fromutc: dt.tzinfo is not self

I am not really sure about this, but for a timezone of +02:00, shouldn't we represent the 0 as "1970-01-01 02:00:00 +02:00"?

The other should not crash imo.

Issue Links

• links to: GitHub Pull Request #11574