Re: How to make a TIMESTAMP_ADD call using RelBuilder?

[Hongze Zhang]

Mail format is converted to something bad :(
The example:

final RexNode shiftedDateField =
   relBuilder.call(
       SqlStdOperatorTable.DATETIME_PLUS,
rexBuilder.makeTimestampLiteral(new TimestampString(2019, 1, 1, 0, 0, 0), 0),
rexBuilder.makeCall(SqlStdOperatorTable.MULTIPLY,
rexBuilder.makeIntervalLiteral(
               TimeUnit.MONTH.multiplier,
               new SqlIntervalQualifier(TimeUnit.MONTH, null, SqlParserPos.ZERO)
           ),
relBuilder.literal(1)
       )
   );

> On Feb 23, 2019, at 00:03, Hongze Zhang <notify...@126.com> wrote:
> 
>> RexNode shiftedDateField =
>    relBuilder.call(
>        SqlStdOperatorTable.DATETIME_PLUS,
> rexBuilder.makeTimestampLiteral(new TimestampString(2019, 1, 1, 0, 0, 0), 0),
> rexBuilder.makeCall(SqlStdOperatorTable.MULTIPLY,
> rexBuilder.makeIntervalLiteral(
>                TimeUnit.MONTH.multiplier,
>                new SqlIntervalQualifier(TimeUnit.MONTH, null, 
> SqlParserPos.ZERO)
>            ),
> relBuilder.literal(1)
>        )
>    );