pyflink.table.expression.Expression.not_between

Expression.not_between(lower_bound, upper_bound) → Expression[bool]

Returns true if the given expression is not between lower_bound and upper_bound (both inclusive). False otherwise. The parameters must be numeric types or identical comparable types.

e.g. lit(2.1).not_between(2.1, 2.1) leads to false, lit(“2018-05-05”).to_date.not_between(lit(“2018-05-01”).to_date, lit(“2018-05-10”).to_date) leads to false.

Parameters:

• lower_bound – numeric or comparable expression

• upper_bound – numeric or comparable expression

See also

between()

Added in version 1.12.0.