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.