DATE data type provides for storage of a year-month-day in the
range supported by java.sql.Date.
DATE values are stored as fixed strings, and are not affected by the time zone of the server to which you are connected.
Corresponding Compile-time Java Type
JDBC Metadata Type (java.sql.Types)
Here are several notes about using the
DATE data type:
- Dates, 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.
Splice Machine supports the following formats for
yyyy-mm-dd mm/dd/yyyy dd.mm.yyyy
- The first of the three formats above is the java.sql.Date format.
- The year must always be expressed with four digits, while months and days may have either one or two digits.
- Splice Machine also accepts strings in the locale specific date-time format, using the locale of the database server. If there is an ambiguity, the built-in formats above take precedence.
Please see Working With Date and Time
Values in the
for information about using simple arithmetic with
VALUES DATE('1994-02-23'); VALUES '1993-09-01';
- Working with Dates in the Developer’s Guide