apache / datafusion

Apache DataFusion SQL Query Engine
https://datafusion.apache.org/
Apache License 2.0
6.02k stars 1.14k forks source link

Document timezone semantics #10344

Open alamb opened 5 months ago

alamb commented 5 months ago

Is your feature request related to a problem or challenge?

The automatic coercion and comparison rules for timestamps with timezones (especially how timestamps with None) are treated is not clear -- for example https://github.com/apache/datafusion/discussions/10311 from @Abdullahsab3

Describe the solution you'd like

I would like something in the

Describe alternatives you've considered

No response

Additional context

No response

alamb commented 5 months ago

@tustvold do you know of any documentation in arrow-rs? I took a quick look and couldn't find anything

https://docs.rs/arrow/latest/arrow/?search=timezone

Possibly related: https://github.com/apache/datafusion/issues/5823#issuecomment-1492965170

tustvold commented 5 months ago

https://docs.rs/arrow-schema/latest/arrow_schema/enum.DataType.html#variant.Timestamp

On the variant for timestamp