[CALCITE-1124] Add support for timestampadd / timestampdiff functions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Arina Ielchiieva
• Created: 04/Mar/16 09:15
• Updated: 18/Jun/21 09:00
• Resolved: 11/Mar/16 03:35

Description

When calling timestampadd / timestampdiff with first parameter:

(SQL_TSI_)MICROSECOND ((SQL_TSI_)FRAC_SECOND (deprecated but we can leave for older versions compatibility)), (SQL_TSI_)SECOND, (SQL_TSI_)MINUTE, (SQL_TSI_)HOUR, (SQL_TSI_)DAY, (SQL_TSI_)WEEK, (SQL_TSI_)MONTH, (SQL_TSI_)QUARTER, (SQL_TSI_)YEAR

(ex: timestampadd(second, 1, current_datetime), calcite throws an error:

Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered "( SECOND" at line 1, column 25.
Was expecting one of:
"(" "*" ...
"(" ")" ...
"(" "WITH" ...

Issue Links

• links to: PR #204