Date Data Type

The following rules apply to the table column values of date data type:

A string representation of a date is a string that starts with a digit and has a length of at least eight characters.
Trailing blanks are included.
Leading blanks are not valid.
Leading zeros are omitted in the month and day portions.
Year, month, and day must all be nonzero.

The following table displays the valid string formats for dates. Each format is identified by a name and includes an associated abbreviation (for use by the CHAR function) and an example of its use:

Format Name	Abbreviation	Date Format	Example
International Standards Organization	ISO	yyyy-mm-dd	1987-10-12
IBM® USA standard	USA	mm/dd/yyyy	10/12/1987
IBM European standard	EUR	dd.mm.yyyy	12.10.1987
Japanese industrial standard Christian era	JIS	yyyy-mm-dd	1987-10-12