DATE provides for storage of a year-month-day in the range supported by java.sql.Date.
Corresponding Compile-Time Java Type
JDBC Metadata Type (java.sql.Types)
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.
VALUES DATE('1994-02-23') VALUES '1993-09-01'
Table of Contents