[
https://issues.apache.org/jira/browse/PHOENIX-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16075597#comment-16075597
]
Julian Hyde commented on PHOENIX-3993:
--------------------------------------
There is an open case for this, CALCITE-304 which covers DATE and could also
cover TIMESTAMP.
I'm not sure what the behavior should be when adding an integer to a TIME
value. I'm pretty sure that Oracle would not add milliseconds.
> Make use of DATETIME_PLUS operator in calcite for arithmetics on DATE and TIME
> ------------------------------------------------------------------------------
>
> Key: PHOENIX-3993
> URL: https://issues.apache.org/jira/browse/PHOENIX-3993
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Rajeshbabu Chintaguntla
> Assignee: Rajeshbabu Chintaguntla
> Labels: calcite, calcite-compat-change
>
> Syntax of arithmetics on DATE or TIME type are different in calcite but in
> phoenix we can use + and - for the same. For example
> {noformat}
> date '2014-02-11' + interval '2' day
> {noformat}
> So any arithmetics on date or time should replace with it. We need to add it
> as compatibility change so added calcite-compat-change flag to it.
> Wdyt [~jamestaylor] [~julianhyde] [~maryannxue]?
> FYI [[email protected]].
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
