[ https://issues.apache.org/jira/browse/CALCITE-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16495888#comment-16495888 ]
Julian Hyde commented on CALCITE-2339: -------------------------------------- My point about WEEK is that 99.2% (I'm guessing) of intervals in real-world SQL are one of the core interval types. So WEEK is not really worth worrying about. > 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)