Cast from string to date with "/"

[matthewmturner]

Is your feature request related to a problem or challenge?

I want to be able to cast a string that is delimited with "/" to a date the same way that you can when it is delimited with "-". Postgres supports both.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[matthewmturner]

I see there is https://github.com/apache/datafusion/issues/9331 with a draft PR on the arrow-rs side. I have checked in on that

[Omega359]

The to_date function might be an alternative. to_date('2024/01/01', '%Y/%m/%d');