You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2016/03/04 10:16:40 UTC

[jira] [Created] (CALCITE-1124) Add support for timestampadd / timestampdiff functions

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)