The DATE Data Type stores date values without time components.

Declaration


DATE

Additional Information

  • Allows date formats compliant with the java.sql.Date method. The following three formats are explicitly supported:

    • yyyy-mm-dd

    • mm/dd/yyyy

    • dd.mm.yyyy

    Use this information when declaring column types with the CREATE TABLE statement or casting values to new data_types for use in functions or output.

    • Convert values to the same type with the CAST function.

Examples


DATE
2012-06-20

DATE
06/20/2012