[ARROW-12391] [Rust][DataFusion] Implement date_trunc() function

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 3.0.0
• Fix Version/s: 5.0.0
• Component/s: Rust - DataFusion
• External issue URL: https://github.com/apache/arrow/issues/28185
• Assignee: Unassigned
• Reporter: Evan Chan
• Created: 14/Apr/21 20:50
• Updated: 11/Jan/23 08:26
• Resolved: 26/Apr/21 13:33

Description

Implement the date_trunc function, as described in this PostGres manual:

https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

 

This would allow for the following use cases to be solved:

• casting of timestamps to other resolutions, such as millis and micros
• rounding dates/timestamps 

It also allows the user to explicitly allow the truncation of timestamp precision.