Hello Hongze,
Thanks for responding. Your suggestion worked splendidly. I've got one more
clarification if its not too much trouble. The following RelNode:
*RelDataType any = builder.getTypeFactory().createSqlType(SqlTypeName.ANY);*
*ImmutableList constExps =
Hi RamKrishna,
As you said:
> So, basically I need to add 2 Hours to CurrentTime.
I think the generated function call "TIMESTAMPADD(HOUR, 2,
CURRENT_TIMESTAMP)" already did that.
If what you want is to compare it's value with a MySQL's Date (with
format -xx-xx), based on Christopher's