[EPIC] Additional Date/Time related open issues

[alamb]

This is a follow on ticket to https://github.com/apache/arrow-datafusion/issues/3148 given we have closed so many of the previous items it is hard to see what is still left to do

Please edit the list or comment bellow if you find something not listed here.

Documentation

• [ ] https://github.com/apache/datafusion/issues/10344

Date/Time/Timestamp Types & Casting

• [x] https://github.com/apache/arrow-datafusion/issues/5398
• [x] https://github.com/apache/arrow-datafusion/issues/7868
• [x] #8336
• [x] #8370
• [x] https://github.com/apache/arrow-datafusion/issues/8465
• [ ] https://github.com/apache/arrow-datafusion/issues/8468
• [ ] https://github.com/apache/arrow-datafusion/issues/8915

TimestampTz Date Types & Casting & Coercion

• [ ] #3080
• [ ] https://github.com/apache/datafusion/issues/10368

Intervals

• [ ] https://github.com/apache/arrow-datafusion/issues/6327

Arithmetic (including intervals)

• [x] https://github.com/apache/arrow-datafusion/issues/8275
• [ ] https://github.com/apache/arrow-datafusion/issues/6876

Functions

• [ ] #1992
• [ ] #686
• [ ] #3996
• [x] #5568
• [ ] #6951
• [x] https://github.com/apache/arrow-datafusion/issues/9024
• [x] https://github.com/apache/arrow-datafusion/issues/9147

parquet/csv/json

• [x] https://github.com/apache/arrow-datafusion/issues/7958

others

• [ ] apache/arrow-rs#902
• [x] #959

[comphead]

oh wow, thanks @alamb

[alamb]

FYI @Omega359 in case you are interested in other things we have identified

[alamb]

Added https://github.com/apache/datafusion/issues/10344 to document the semantics of timezones