Comparison operators - Amazon Timestream

Comparison operators

Timestream supports the following comparison operators.

Operator Description

<

Less than

>

Greater than

<=

Less than or equal to

>=

Greater than or equal to

=

Equal

<>

Not equal

!=

Not equal

Note
  • The BETWEEN operator tests if a value is within a specified range. The syntax is as follows:

    BETWEEN min AND max

    The presence of NULL in a BETWEEN or NOT BETWEEN statement will result in the statement evaluating to NULL.

  • IS NULL and IS NOT NULL operators test whether a value is null (undefined). Using NULL with IS NULL evaluates to true.

  • In SQL, a NULL value signifies an unknown value.