Enum StandardSQLTypeName (2.5.1)

public enum StandardSQLTypeName extends Enum<StandardSQLTypeName>

A type used in standard SQL contexts. For example, these types are used in queries with query parameters, which requires usage of standard SQL.

Fields

NameDescription
ARRAY

Ordered list of zero or more elements of any non-array type.

BIGNUMERIC

A decimal value with 76+ digits of precision (the 77th digit is partial) and 38 digits of scale

BOOL

A Boolean value (true or false).

BYTES

Variable-length binary data.

DATE

Represents a logical calendar date. Values range between the years 1 and 9999, inclusive.

DATETIME

Represents a year, month, day, hour, minute, second, and subsecond (microsecond precision).

FLOAT64

A 64-bit IEEE binary floating-point value.

GEOGRAPHY

Represents a set of geographic points, represented as a Well Known Text (WKT) string.

INT64

A 64-bit signed integer value.

NUMERIC

A decimal value with 38 digits of precision and 9 digits of scale.

STRING

Variable-length character (Unicode) data.

STRUCT

Container of ordered fields each with a type (required) and field name (optional).

TIME

Represents a time, independent of a specific date, to microsecond precision.

TIMESTAMP

Represents an absolute point in time, with microsecond precision. Values range between the years 1 and 9999, inclusive.

Methods

NameDescription
valueOf(String name)
values()