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




Not equal


Not equal

  • 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.