Add tests for casting between timestamp types #467
Description
What is the problem the feature request solves?
We currently delegate to DataFusion when casting between timestamps (as discovered in #461) but I am not convinced that we have comprehensive tests to ensure that this is compatible with Spark.
This issue is for adding specific tests for casting between timestamp types.
Describe the potential solution
No response
Additional context
No response