Abdullahsab3 commented on issue #10368: URL: https://github.com/apache/datafusion/issues/10368#issuecomment-2096289545
Thanks for the response! > I think we should not return 9:00:00, because the local time for timezone +1 is 8:00:00. I wonder whether it has to do with the `at time zone` operator. If we add `at time zone 'UTC'` in between for instance, we would be getting different results (in postgres): ``` select '2020-11-30T08:00:00.000Z'::timestamp at time zone 'UTC' at time zone 'Europe/Brussels'; --- 2020-11-30 09:00:00.000000 ``` This is the result I would expect See: https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT I think the `at time zone` operator behaviour is to consider the timestamp as a timezone-less timestamp (which I think means that the `Z` will be ignored) Now that I think about it, it might be that what I am proposing is for the `at time zone` operator to have the same behaviour as postgres. I also think that something is not right with the `at time zone` operator in Datafusion -- 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]
