[
https://issues.apache.org/jira/browse/CALCITE-1632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-1632:
---------------------------------
Summary: Return type of "datetime + interval" expression (was: Return
types of datetime + interval)
> Return type of "datetime + interval" expression
> -----------------------------------------------
>
> Key: CALCITE-1632
> URL: https://issues.apache.org/jira/browse/CALCITE-1632
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: 1.12.0
>
>
> 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)
