Data Type | Description | Data Type Examples |
---|
Array | An Array data type is used to store and access the multidimensional data. It can store many values of the same specific data type in a sequential or matrix-like format. | - One-dimensional (1-D) Array
- Multidimensional (n-D) Array
|
Byte | Byte data types store raw data as logical bitstreams. These data types are stored in the client system format. Teradata Database does not translate these data types. The data is transmitted directly from the memory of the client system. | - BYTE
- VARBYTE
- BLOB (Binary Large Object)
|
Character | Character data types represent characters that belong to a given character set. | - CHAR
- VARCHAR
- CLOB (Character Large Object)
|
Dataset | A complex data type that represents self-describing data stored in a format conforming to some schema. | AVRO |
DateTime | DateTime data types represent a date, time, and timestamp values. | - DATE
- TIME
- TIMESTAMP
- TIME WITH TIME ZONE
- TIMESTAMP WITH TIME ZONE
|
Geospatial | Geospatial data types represent geographic information and provide a way for applications that manage, analyze, and display geographic information to interface with Teradata Database. | - ST_Geometry
- MBR
|
Interval | Interval data types represent a period. For example, an Interval value can represent a period that includes several years, months, days, hours, minutes, or seconds. | - Interval Year
- Interval Year to Month
- Interval Month
- Interval Day
- Interval Day to Hour
- Interval Day to Minute
- Interval Day to Second
- Interval Hour
- Interval Hour to Minute
- Interval Hour to second
- Interval Minute
- Interval Minute to second
- Interval Second
|
JSON | The JSON data type represents that data which are in JavaScript Object Notation format. | JSON |
Numeric | Numeric data types represent a numeric value that is an exact numeric number such as integer or decimal or an approximate numeric number such as floating-point. | - BYTEINT
- SMALLINT
- INTEGER
- BIGINT
- DECIMAL/NUMERIC
- FLOAT/REAL/DOUBLE PRECISION
- NUMBER
|
Parameter | Parameter data types are used only with input or result parameters in a function, method, stored procedure, or external stored procedure. | - TD_ANYTYPE
- VARIANT_TYPE
|
Period | A Period data type represents a time period, where a period is a set of contiguous time granules that extends from a beginning bound up to but not including an ending bound. | - PERIOD(DATE)
- PERIOD(TIME)
- PERIOD(TIME WITH TIME ZONE)
- PERIOD(TIMESTAMP)
- PERIOD(TIMESTAMP WITH TIME ZONE)
|
UDT | UDT (User-Defined Type) data types are custom data types that are defined to model the structure and behavior of the data used by the applications. | - Distinct
- Structured
|
XML | The XML data type represents XML content. The data is stored in a compact binary form that preserves the XML document's information set, including the hierarchy information and type information derived from XML validation. | XML |