[FEA] Support temporal types in to_json

[andygrove]

Is your feature request related to a problem? Please describe.
PR #9486 added basic support for to_json, but did not add support for temporal types.

Describe the solution you'd like
Add support for temporal types. We need to look at the date/time format json data source options and see if they apply when calling to_json.

https://spark.apache.org/docs/latest/sql-data-sources-json.html#data-source-option

Describe alternatives you've considered

Additional context

[andygrove]

Fixed in #9600