ESQL DATE data type

The DATE data type holds a Gregorian calendar date (year, month, and day).

The format of a DATE literal is the word DATE followed by a space, followed by a date in single quotation marks in the form 'yyyy-MM-dd'. For example:
DECLARE MyDate DATE;
SET MyDate = DATE '2000-02-29';
Do not omit leading zeros from the year, month, and day.