Declares a date value in ANSI DATE format in an expression.
ANSI DATE literal is the preferred format for date constants. All date operations accept this format.
Syntax
DATE 'string'
- string
- A 10-character string enclosed in apostrophes in the following form:
Usage Notes
Date literals consist of the word DATE followed by a character string literal. This character string specifies the date value.
The year, month, and day components of the string literal must be separated by hyphens.
Spaces and new line characters are not allowed in a literal except after the keyword DATE.
Data Type
DATE
Example: Date Literals
The following example selects all classes from the Classes table that start on January 6, 1998.
SELECT * FROM CLASSES WHERE startdate = DATE '1998-01-06';
Related Topics
For information on DATE data types, see DATE Data Type.