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