### Describe the bug `date_part` doesn't work for timestamptz with non-utc timezone ### To Reproduce `arrow_cast` allows us to cast timestamp to timestamptz (though the behavior of arrow_cast is incorrect now #5952) ```bash ❯ select arrow_cast('2000-01-01T00:00:00'::timestamp, 'Timestamp(Nanosecond, Some("+08:00"))'); +-----------------------------+ | Utf8("2000-01-01T00:00:00") | +-----------------------------+ | 2000-01-01T08:00:00+08:00 | +-----------------------------+ 1 row in set. Query took 0.002 seconds. ``` ```bash ❯ select date_part('hour', arrow_cast('2000-01-01T00:00:00'::timestamp, 'Timestamp(Nanosecond, Some("+08:00"))')); +----------------------------------------------------+ | datepart(Utf8("hour"),Utf8("2000-01-01T00:00:00")) | +----------------------------------------------------+ | 0.0 | +----------------------------------------------------+ 1 row in set. Query took 0.003 seconds. ``` ### Expected behavior should returns 8.0 ### Additional context cc @tustvold will https://github.com/apache/arrow-rs/issues/1936 solve this?