[
https://issues.apache.org/jira/browse/CALCITE-1663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15886326#comment-15886326
]
Julian Hyde commented on CALCITE-1663:
--------------------------------------
My goal was to do as little as possible, namely to make {{TIMESTAMPDIFF(u, t1,
t2)}} just syntactic sugar for {{(t1 - t2) u}}, because the latter is in the
standard. Which is why we tend to accept DATE and TIME in addition to TIMESTAMP.
In my opinion, this issue is valid but not high priority.
> TIMESTAMPDIFF declares operand type DATETIME instead of TIMESTMAP
> -----------------------------------------------------------------
>
> Key: CALCITE-1663
> URL: https://issues.apache.org/jira/browse/CALCITE-1663
> Project: Calcite
> Issue Type: Bug
> Reporter: Remus Rusanu
> Assignee: Julian Hyde
>
> {{SqlTimestampDiffFunction}} operands are declared
> {{SqlTypeFamily.DATETIME}}, not {{SqlTypeFamily.TIMESTAMP}}.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
