The DATE data type is used to represent the year (yyyy), month (mm) and day (dd). Supported range is "01/01/0001" to "12/31/9999." The year can be omitted. If it is, the year value of the current system is specified automatically.
Output and input formats are as follows:
'mm/dd[/yyyy]'
'[yyyy-]mm-dd'
DATE '2008-10-31' is stored as '10/31/2008'.
DATE '10/31' is stored as '10/31/2011'(if a value for year is omitted, the current year is automatically specified).
DATE '00-10-31' is stored as '10/31/2000'.
DATE '0000-10-31' is handled as an error (a year value should be at least 1).
DATE '70-10-31' is stored as '10/31/1970'.
DATE '0070-10-31' is stored as '10/31/0070'.