DSQL, PSQL, ESQL

'YESTERDAY' is not a variable but a string literal. It is, however, special in the sense that when you it to a date/time type, you will get the date of the day before. See also .

Shorthand syntax for the last two statements: