If the function TIMESTAMPADD is not supported in Oracle, in general the OracleSqlDialect should translate it to some other expressions or calls. But it seems that currently the dialect does not provide the translation[1].
It would be great if you can log a JIRA case to describe your issue, or even contribute a PR to solve the problem. Best, Hongze [1] https://github.com/apache/calcite/blob/50012d221d6e9a5e42a957ab0723e0f706b25be3/core/src/main/java/org/apache/calcite/sql/dialect/OracleSqlDialect.java#L55 > On Mar 8, 2019, at 7:13 PM, Rakesh Nair <ramkrs...@gmail.com> wrote: > > TIMESTAMPADD