cast format 'yyyymmdd' to Date32 give a error

[Tangruilin]

Describe the bug
when cast string like '19990819' to Date32, it will give a error， but for '1999-08-19' it secceed

To Reproduce
In arrow-datafusion
For a date column run a query with the date in string format 'yyyymmdd' as shown below

--this query fails
select * from orders where o_orderdate = '19961006'

it get

Arrow error: Cast error: Cannot cast string '19961006' to value of Date32 type

Expected behavior
This should return the correct result and not fail

Additional context

[Tangruilin]

@alamb hey! the bug for apache/datafusion#7465 is belong to this, maybe this issue can be assigned to me and i will fix it

[alamb]

Assigned -- thanks @Tangruilin

@tustvold can you confirm this is a reasonable change to add to arrow-rs? If not, I think we should add the code to DataFusion instead

[tustvold]

I see no issue with this

[Tangruilin]

@alamb @tustvold

[Tangruilin]

I have initiated a PR, thanks for review

[tustvold]

label_issue.py automatically added labels {'arrow'} from #5078