Re:How to make a TIMESTAMP_ADD call using RelBuilder?

2019-02-22 Thread Hongze Zhang
Correct the flag: TimeUnitRange.MONTH -> TimeUnit.MONTH Best, Hongze At 2019-02-22 22:07:11, "Hongze Zhang" wrote: Hi Anton, Following code works to me: final RexNode shiftedDateField = relBuilder.call( SqlStdOperatorTable.TIMESTAMP_ADD,

Re:How to make a TIMESTAMP_ADD call using RelBuilder?

2019-02-22 Thread Hongze Zhang
Hi Anton, Following code works to me: final RexNode shiftedDateField = relBuilder.call( SqlStdOperatorTable.TIMESTAMP_ADD, relBuilder.getRexBuilder().makeFlag(TimeUnitRange.MONTH), relBuilder.literal(1), relBuilder.getRexBuilder().makeDateLiteral(new