DSQL, PSQL, ESQL

    Type

    Description

    'TODAY' is not a variable but a string literal. It is, however, special in the sense that when you CAST() it to a date/time type, you will get the current date. is case-insensitive, and the engine ignores leading or trailing spaces when casting.

    for the last two statements:

      Notes