[ARROW-10759] [Rust][DataFusion] Implement support for casting string to date in sql expressions

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 3.0.0
• Component/s: Rust - DataFusion
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/26703
• Assignee: Yordan Pavlov
• Reporter: Yordan Pavlov
• Created: 28/Nov/20 16:01
• Updated: 11/Jan/23 08:15
• Resolved: 02/Dec/20 16:59

Description

If DataFusion had support for creating date literals using a cast expression such as 
CAST('2019-01-01' AS DATE) this would allow a user-friendly way for direct (and therefore more efficient) comparison of date columns to scalar values (compared to representing dates as strings and then resorting to string comparison).
I already have a basic implementation that works, just have to add some more tests.

Issue Links

• links to: GitHub Pull Request #8794