Hello. In SQL, I can execute a query like "SELECT TIMESTAMPADD(month,
1, "date" ) FROM ..." and it works. But my attempts to do the same
thing using RelBuilder are not successful, for example, this code does
not work:

RexNode shiftedDateField = relBuilder.call(
    SqlStdOperatorTable.TIMESTAMP_ADD,
    relBuilder.literal("month"),
    relBuilder.literal(1),
    dateFieldRef
);

Could you please tell me, how to make a TIMESTAMP_ADD call using RelBuilder?
-- 
Best regards,
Anton.

Reply via email to