Andrew Lamb

I hvaen't seen this happen recently: ```shell (venv) andrewlamb@Andrews-MacBook-Pro-2:~/Software/datafusion2/docs$ ./build.sh Running Sphinx v7.2.6 making output directory... done [autosummary] generating autosummary for: contributor-guide/architecture.md, contributor-guide/communication.md, contributor-guide/getting_started.md, contributor-guide/governance.md, contributor-guide/howtos.md, contributor-guide/index.md, contributor-guide/inviting.md, contributor-guide/quarterly_roadmap.md, contributor-guide/roadmap.md,...

The way you can perform this binning in postgres is somewhat paradoxically to convert a timestamp with a timezone back to a timestamp without timezone and then apply `date_bin`. The...

If we cast using arrow_cast back to `Timestamp(Nanosecond, None)` the binning does appear to work correctly ```sql > create or replace view t_roundtrip as select arrow_cast(column1, 'Timestamp(Nanosecond, None)') as "column1"...

Given the statement in the description, here is the best I can come up with using `arrow_cast` ```sql -- Times in brussels WITH t_brussels AS ( SELECT column1 AT TIME...

@mhilton and I agree that if we had the functionality suggested by @Abdullahsab3's on https://github.com/apache/datafusion/issues/10368#issue-2277903243 > given a UTC timestamp, I would like to have that timestamp in local time...

My suggested next steps for this ticket: 1. Someone prototype the "strip_timezone" function as a ScalarUDF and verify that we can in fact we can achieve the expected result from...

> I'm curious as to why we wouldn't want to just make date_bin timezone aware? This would appear to have a lot less potential edge cases I believe @mhilton had...

Thank you @tustvold and @Abdullahsab3 and @mhilton and @appletreeisyellow for the thoughts. From my perspective, the current (non timezone aware) `date_bin` function has the benefit of being (relatively) simple to...

@appletreeisyellow and I just had a chat about what to do about this ticket. It is great that we seem to have found a workaround there are at least two...

I filed https://github.com/apache/arrow-rs/pull/5826 to document more precisely what is going on with casting