Feature: support cast date to timestamp with tz

[xudong963]

Is your feature request related to a problem or challenge?

> select to_char(arrow_cast('2023-09-04'::date, 'Timestamp(Second, Some("UTC"))'), '%Y-%m-%dT%H:%M:%S%.3f');
This feature is not implemented: Unsupported CAST from Date32 to Timestamp(Second, Some("UTC"))

Describe the solution you'd like

No response

Describe alternatives you've considered

Maybe it should be implemented in arrow-rs?

Additional context

No response

[xudong963]

It seems that Date32/Date64 doesn't support TZ, so if we want to support the cast, we should add TZ to Date32/Date64 firstly?

[friendlymatthew]

take

[friendlymatthew]

It seems that Date32/Date64 doesn't support TZ, so if we want to support the cast, we should add TZ to Date32/Date64 firstly?

I'm not sure if Date types should be time-zone aware. Postgres has a similar Date time and does not allow dates with associated time zones.

However when casting a Date into a Timestamp, we should definitely support various time zones! I've posted a PR for that.

[friendlymatthew]

Datafusion-wise, I tested this feature in this branch and it works as expected:

> select to_char(arrow_cast('2023-09-04'::date, 'Timestamp(Second, Some("UTC"))'), '%Y-%m-%dT%H:%M:%S%.3f');
+--------------------------------------------------------------------------------------------------------------+
| to_char(arrow_cast(Utf8("2023-09-04"),Utf8("Timestamp(Second, Some("UTC"))")),Utf8("%Y-%m-%dT%H:%M:%S%.3f")) |
+--------------------------------------------------------------------------------------------------------------+
| 2023-09-04T00:00:00.000                                                                                      |
+--------------------------------------------------------------------------------------------------------------+
1 row(s) fetched.
Elapsed 0.027 seconds.

Once apache/arrow-rs#7141 lands, I'll follow up with some test cases in cast.slt.