On this page 
Warning:
CockroachDB v1.1 is no longer supported. For more details, see the Release Support Policy.
The DATE data type stores a year, month, and day.
Syntax
A constant value of type DATE can be expressed using an
interpreted literal, or a
string literal
annotated with
type DATE or
coerced to type
DATE.
The string format for dates is YYYY-MM-DD. For example: DATE '2016-12-23'.
CockroachDB also supports using uninterpreted
string literals in contexts
where a DATE value is otherwise expected.
Size
A DATE column supports values up to 8 bytes in width, but the total storage size is likely to be larger due to CockroachDB metadata.
Examples
> CREATE TABLE dates (a DATE PRIMARY KEY, b INT);
> SHOW COLUMNS FROM dates;
+-------+------+-------+---------+
| Field | Type | Null | Default |
+-------+------+-------+---------+
| a | DATE | false | NULL |
| b | INT | true | NULL |
+-------+------+-------+---------+
> -- explicitly typed DATE literal
> INSERT INTO dates VALUES (DATE '2016-03-26', 12345);
> -- string literal implicitly typed as DATE
> INSERT INTO dates VALUES ('2016-03-27', 12345);
> SELECT * FROM dates;
+---------------------------+-------+
| a | b |
+---------------------------+-------+
| 2016-03-26 00:00:00+00:00 | 12345 |
| 2016-03-27 00:00:00+00:00 | 12345 |
+---------------------------+-------+
Supported Casting & Conversion
DATE values can be cast to any of the following data types:
| Type | Details |
|---|---|
INT |
Converts to number of days since the Unix epoch (Jan. 1, 1970). This is a CockroachDB experimental feature which may be changed without notice. |
DECIMAL |
Converts to number of days since the Unix epoch (Jan. 1, 1970). This is a CockroachDB experimental feature which may be changed without notice. |
FLOAT |
Converts to number of days since the Unix epoch (Jan. 1, 1970). This is a CockroachDB experimental feature which may be changed without notice. |
TIMESTAMP |
Sets the time to 00:00 (midnight) in the resulting timestamp |
STRING |
–– |
Note:
Because the SERIAL data type represents values automatically generated by CockroachDB to uniquely identify rows, you cannot meaningfully cast other data types as SERIAL values.See Also
Was this helpful?
