DATE data type consists of day, month and year. A DATE literal is represented as a character string. The character string follows the DATE keyword as shown below.
mm is month, dd is day, and yyyy is year. If there is no year entered, the current year will be specified automatically.
All fields must be entered in integral form.
DATE '11/11/1994' is stored as '11/11/1994'.
DATE '11/11' is stored as '11/11/2009'. (if a value for year is omitted, the current year is automatically specified.)