[EPIC] Additional Date/Time related open issues

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

- [x] #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
- [x] #686
- [ ] #3996
- [x] #5568
- [x] #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

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

Start by reviewing the unchecked linked issues in the Documentation, Date/Time/Timestamp Types & Casting, TimestampTz, Intervals, Arithmetic, and Functions sections. Determine which individual issue is still actionable and follow its stated scope; this epic is done when the remaining items are resolved or the checklist is updated.

Written by the indexing model from the issue text.