DATE

The DATE data type 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

Usage Notes

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 DATE:
    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 DATE values.

Examples

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

See Also