pyflink.table.expression.Expression.between

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

Returns true if the given expression is 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).between(2.1, 2.1) leads to true, lit(“2018-05-05”).to_date.between(lit(“2018-05-01”).to_date, lit(“2018-05-10”).to_date) leads to true.

Parameters:

• lower_bound – numeric or comparable expression

• upper_bound – numeric or comparable expression

See also

not_between()

Added in version 1.12.0.