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

Posted to dev@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2017/02/14 20:35:41 UTC

[jira] [Created] (CALCITE-1632) Return types of datetime + interval

Julian Hyde created CALCITE-1632:
------------------------------------

             Summary: Return types of datetime + interval
                 Key: CALCITE-1632
                 URL: https://issues.apache.org/jira/browse/CALCITE-1632
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Per the SQL standard, the return type of "datetime + interval" is the same as the type of "datetime". (Postgres, for instance, always widens the result to TIMESTAMP; this is wrong.)

Also, when adding or subtracting to a TIME value, make sure the result stays within the range 00:00:00..23:59:59.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)