[SPARK-38389] Add the `DATEDIFF` and `DATE_DIFF` aliases for `TIMESTAMPDIFF()`

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Epic Link: New functions in Spark SQL 3.3
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 02/Mar/22 08:54
• Updated: 11/Aug/23 17:01
• Resolved: 02/Mar/22 16:42

Description

Introduce the datediff()/date_diff() function, which takes three arguments: unit, and two datetime expressions, i.e.,

datediff(unit, startDatetime, endDatetime)

The function can be an alias to timestampdiff().

Issue Links

• is a clone of: SPARK-38332 Add the `DATEADD()` alias for `TIMESTAMPADD()`
• is cloned by: SPARK-44778 Add the `TIMEDIFF` aliases for `TIMESTAMPDIFF()`
• links to: [Github] Pull Request #35709 (MaxGekk)