osawyerr opened a new issue, #7465: URL: https://github.com/apache/arrow-datafusion/issues/7465
### Describe the bug Hi there. When running queries with date filters that are in the format 'yyyymmdd' , DataFusion throws an error. This is valid Postgres syntax. However dats in the format 'yyyy-mm-dd' succeed. Both are valid postgres syntax. For both queries below, both are valid postgres syntax however: ```sql --this query fails select * from orders where o_orderdate = '19961006' --but this succeeds select * from orders where o_orderdate = '1996-10-06' ``` ### To Reproduce For a date column run a query with the date in string format ``'yyyymmdd'`` as shown below ```sql select * from orders where o_orderdate = '19961006' ``` Error thrown is ``` 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 _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
