[SPARK-38195] Add the TIMESTAMPADD() function

• 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: 13/Feb/22 16:24
• Updated: 04/Apr/22 09:18
• Resolved: 18/Feb/22 05:51

Description

The function TIMESTAMPADD() is a part of the ODBC api and implemented virtually by ALL other databases are missing in Spark SQL.

The first argument is an unary interval (HOUR, YEAR, DAY, etc)

TIMESTAMPADD( SECOND, 2 , timestamp '2021-12-12 12:00:00.00') returns 2021-12-12 12:00:02.00

The ODBC syntax requires the interval value to have a prefix of sql_tsi_ while plain sql doesn't. See

• Time, Date, and Interval Functions
• TIMESTAMPADD function (ODBC compatible)

Issue Links

• blocks: SPARK-38332 Add the `DATEADD()` alias for `TIMESTAMPADD()`
• is a parent of: SPARK-38535 Add the datetimeUnit enum to the grammar and use it in TIMESTAMPADD/DIFF
• links to: [Github] Pull Request #35502 (MaxGekk)