alamb opened a new issue, #5164: URL: https://github.com/apache/arrow-datafusion/issues/5164
**Describe the bug** After https://github.com/apache/arrow-datafusion/pull/5140 and https://github.com/apache/arrow-datafusion/pull/5117 we can cast strings to Timestamp without a timezone. However, casting with timezone is not working yet, as noticed by @waitingkuo **To Reproduce** In `datafusion-cli`: ```sql ❯ select '2000-01-01T00:00:00'::timestamp::timestamptz = '2000-01-01T00:00:00'; Internal("The type of Timestamp(Nanosecond, Some(\"+00:00\")) Eq Utf8 of binary physical should be same") ❯ select '2000-01-01T00:00:00'::timestamp = '2000-01-01T00:00:00'; +-----------------------------------------------------------+ | Utf8("2000-01-01T00:00:00") = Utf8("2000-01-01T00:00:00") | +-----------------------------------------------------------+ | true | +-----------------------------------------------------------+ 1 row in set. Query took 0.004 seconds. ❯ select '2000-01-01T00:00:00'::timestamptz = '2000-01-01T00:00:00'; NotImplemented("Unsupported CAST from Utf8 to Timestamp(Nanosecond, Some(\"+00:00\"))") ```` **Expected behavior** I expect all three queries to run and return `true` **Additional context** Add any other context about the problem here. -- 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]
