Here is a table that shows the various supported data types:
|
Type |
Size in bytes |
Name (standard SQL) |
Description |
|
Integer |
8 |
INT64 |
Numeric value with no fraction |
|
Floating point |
8 |
FLOAT64 |
Double-precision decimal value |
|
Boolean |
Unset |
BOOL |
True or false value |
|
String |
Unset |
STRING |
Character data of variable length |
|
Bytes |
Unset |
BYTES |
Variable-length binary |
|
Date |
Unset |
DATE |
Logical calendar date |
|
Datetime |
Unset |
DATETIME |
Year, month, day, hour, minute, second, and subsecond |
|
Time |
Unset |
TIME |
A time, independent of a specific date |
|
Timestamp |
Unset |
TIMESTAMP |
Time with a microsecond precision |
|
Array |
Unset |
ARRAY |
An ordered list of elements of any non-array type. This is available for querying only in Standard SQL. |
|
Struct |
Unset |
STRUCT |
A container of ordered fields, each with a type and field name. This is available for querying only in Standard SQL. |