[SPARK-38535] Add the datetimeUnit enum to the grammar and use it in TIMESTAMPADD/DIFF

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 12/Mar/22 11:49
• Updated: 14/Mar/22 09:20
• Resolved: 14/Mar/22 09:20

Description

Add the following enum:

datetimeUnit
    : YEAR | QUARTER | MONTH
    | WEEK | DAY | DAYOFYEAR
    | HOUR | MINUTE | SECOND | MILLISECOND | MICROSECOND
    ;

and use it in the grammar rules for TIMESTAMPADD and TIMESTAMPDIFF.

 

Issue Links

• is a child of: SPARK-38195 Add the TIMESTAMPADD() function
• is a child of: SPARK-38284 Add the TIMESTAMPDIFF() function
• links to: [Github] Pull Request #35826 (MaxGekk)