alamb commented on issue #11653: URL: https://github.com/apache/datafusion/issues/11653#issuecomment-2251189779
I suggest coercing both timestamps to UTC My rationale is that: 1. To the best of my knowledge, there should be a 1->1 mapping from a timestamp in any timezone to UTC 2. It is **not clear** to me that there is a 1->1 mapping from every timestamp in any timezone to a timestamp in any other timezone (like during DST conversion I think sometimes there are multiple times with the same UTC time in a ceratin timestamp) 3. Since the coercion rules are for comparison (and will result in the output type `boolean`) I don't think the choice of UTC (over the given timezone) would affect the output of the query. -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
