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)