The DATE data type holds a Gregorian calendar date (year, month, and day).
DECLARE MyDate DATE; SET MyDate = DATE '2000-02-29';