| title | summary | toc |
|---|---|---|
Data Types |
Learn about the data types supported by CockroachDB. |
false |
CockroachDB supports the following data types. Click a type for more details.
| Type | Description | Example |
|---|---|---|
INT |
A 64-bit signed integer. | 12345 |
SERIAL |
A unique 64-bit signed integer. | 148591304110702593 |
DECIMAL |
An exact, fixed-point number. | 1.2345 |
FLOAT |
A 64-bit, inexact, floating-point number. | 1.2345 |
BOOL |
A Boolean value. | true |
DATE |
A date. | DATE '2016-01-25' |
TIMESTAMP |
A date and time pairing. | TIMESTAMP '2016-01-25 10:10:10' |
INTERVAL |
A span of time. | INTERVAL '2h30m30s' |
STRING |
A string of Unicode characters. | 'a1b2c3' |
BYTES |
A string of binary characters. | b'\141\061\142\062\143\063' |