Arina Ielchiieva created CALCITE-1124:
-----------------------------------------
Summary: Add support for timestampadd / timestampdiff functions
Key: CALCITE-1124
URL: https://issues.apache.org/jira/browse/CALCITE-1124
Project: Calcite
Issue Type: Improvement
Components: core
Affects Versions: next
Reporter: Arina Ielchiieva
Assignee: Julian Hyde
When calling timestampadd / timestampdiff with first parameter:
MICROSECOND (MICROSECONDS, FRAC_SECOND (deprecated)), (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" ...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
