3. Understanding SQL Data Types : Literals : Date and Time Literals : Date Literals
 
Share this page                  
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'