findepi commented on issue #11653: URL: https://github.com/apache/datafusion/issues/11653#issuecomment-2251447571
> 1. To the best of my knowledge, there should be a 1->1 mapping from a timestamp in any timezone to UTC at least in SQL spec, the `timestamp with time zone` has point-in-time semantics, and every point in time has its representation in UTC > 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. can the comparison operator be a function that accepts timestamps in _different zones_? -- 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]
