[SPARK-38332] Add the `DATEADD()` alias for `TIMESTAMPADD()`

• 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: 25/Feb/22 19:30
• Updated: 04/Apr/22 09:22
• Resolved: 28/Feb/22 14:46

Description

Introduce the dateadd() function, which takes three arguments: unit, number of units and datetime expression, i.e.,

dateadd(unit, number_of_units, expr)

The function can be an alias to timestampadd().

Issue Links

• is blocked by: SPARK-38195 Add the TIMESTAMPADD() function
• is cloned by: SPARK-38389 Add the `DATEDIFF` and `DATE_DIFF` aliases for `TIMESTAMPDIFF()`
• links to: [Github] Pull Request #35661 (MaxGekk)