waitingkuo opened a new issue, #5975:
URL: https://github.com/apache/arrow-datafusion/issues/5975
### 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?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
