[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16495873#comment-16495873 ]
Laurent Goujon commented on CALCITE-2339: ----------------------------------------- Could we change the {{DATETIME_PLUS}} operator to support non-standard/internal interval types so that WEEK can be represented as such and being preserved up to each adapter? > JDBC adapter should transform timestamp arithmetic for target database > ----------------------------------------------------------------------- > > Key: CALCITE-2339 > URL: https://issues.apache.org/jira/browse/CALCITE-2339 > Project: Calcite > Issue Type: Bug > Reporter: Julian Hyde > Assignee: Julian Hyde > Priority: Major > Attachments: Datetime Addition - Calcite.pdf > > > JDBC adapter should transform timestamp arithmetic for target database. > There are two ways in Calcite to add intervals to timestamps: the > TIMESTAMP_ADD function and the "<timestamp> + <interval>" operator. > The attached document (authored by James Doung) describes their pros and cons. -- This message was sent by Atlassian JIRA (v7.6.3#76005)