DATE

DATE provides for storage of a year-month-day in the range supported by java.sql.Date.

Syntax

DATE

Corresponding Compile-Time Java Type

java.sql.Date

JDBC Metadata Type (java.sql.Types)

DATE

Dates, times, and timestamps must not be mixed with one another in expressions.

Any value that is recognized by the java.sql.Date method is permitted in a column of the corresponding SQL date/time data type.

Examples

VALUES DATE('1994-02-23')
 
VALUES '1993-09-01'