Support for Time and Date types

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
At the moment DataFusion only supports a subset of `DataType::Time` and `DataType::Date` and does not properly account for the units (seconds, milliseconds, microseconds, nanoseconds).

**Describe the solution you'd like**
We should add proper support for the full range of Time and Date types supported by Arrow

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

**Additional context**
Add any other context or screenshots about the feature request here.

Start by locating the DataType::Time and DataType::Date handling in DataFusion and reviewing how Arrow represents seconds, milliseconds, microseconds, and nanoseconds. Define the required coverage for the full range of Arrow time and date types, then verify each unit is handled consistently.

Written by the indexing model from the issue text.