GitHub user Abdullahsab3 closed a discussion: Do timestamps get implicitly casted to another timezone?
While I was looking into https://github.com/apache/datafusion/issues/10308 , I noticed in this query: ``` select date_bin(interval '1 hour', time at time zone 'Europe/Brussels') from raw_data where time >= '2021-03-27T22:00:00.000Z' and time <= '2021-03-29T00:00:00.000Z' -- exclude the daylight savings hour and time not between '2021-03-28T02:00:00Z' and '2021-03-28T03:00:00Z' group by date_bin(interval '1 hour', time at time zone 'Europe/Brussels') ``` that the timestamps in the `where` clause seem to be interpreted as a timestamp with 'Europe/Brussels' timezone, which means that the `Z` seems to be ignored. The `and time not between '2021-03-28T02:00:00Z' and '2021-03-28T03:00:00Z'` clause, for instance, refers to the daylights saving hour in local time, while it should be referring to the hour between 2021-03-28T02:00:00 UTC and 2021-03-28 03:00:00 UTC. Maybe I misunderstood something there 🤔 GitHub link: https://github.com/apache/datafusion/discussions/10311 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
