Date Literals
Literals of the ANSI date type have the following format:
DATE 'date_value'
date_value
Defines a date in the format yyyy-mm-dd.
Note: The II_DATE_FORMAT setting has no impact on the processing of date literals.
Examples:
date '2012-05-29'
date '1998-10-08'
date '2000-11-29'