Data Types - Teradata Vantage - Analytics Database

Database Introduction
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantage™

Every data value must have an SQL data type. When you define a column in a CREATE TABLE statement, you must specify the data type of the column. Vantage supports the following categories of data types. For a complete list of supported data types and detailed information about each data type, see Teradata Vantage™ - Data Types and Literals, B035-1143.

Data Type Category Description Data Type Examples
ARRAY/VARRAY Represents multidimensional data as sequence or matrix. Individual data items have same data type.
  • One-dimensional (1-D) ARRAY
  • Multidimensional (n-D) ARRAY
Byte Represents raw data as logical bit stream in client-system format, not translated by Vantage. Transmitted directly from client system memory.
  • BYTE
  • VARBYTE
  • BLOB (Binary Large Object)
Character Represents characters of given character set.
  • CHAR
  • VARCHAR
  • CLOB (Character Large Object)
DATASET Complex data type that represents self-describing data stored in schema-defined format.
  • AVRO
  • CSV
DateTime Represents date, time, and timestamp values.
  • DATE
  • TIME
  • TIMESTAMP
  • TIME WITH TIME ZONE
  • TIMESTAMP WITH TIME ZONE
Geospatial Represents geographic information and provides applications that use it with interface to Vantage.
  • ST_Geometry
  • MBR
Interval Represents a time span--a number of 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 Represents data that is in JSON (JavaScript Object Notation) format. JSON
Numeric Represents an exact numeric value (integer or decimal) or approximate numeric value (floating point).
  • BYTEINT
  • SMALLINT
  • INTEGER
  • BIGINT
  • DECIMAL/NUMERIC
  • FLOAT/REAL/DOUBLE PRECISION
  • NUMBER
Parameter Used only with input or result parameters in a function, method, stored procedure, or external stored procedure.
  • TD_ANYTYPE
  • VARIANT_TYPE
Period Represents a time period, 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 (User-Defined Type) Data type you define to model the structure and behavior of the data your applications use.
  • Distinct
  • Structured
XML Represents XML data in compact binary form that preserves information set of XML document, including hierarchy and types derived from XML validation. XML
For detailed information on data types and the related functions, procedures, methods, and operators that operate on these types, see the following documents:
  • Teradata Vantage™ - Data Types and Literals, B035-1143
  • Teradata Vantage™ - Geospatial Data Types, B035-1181
  • Teradata Vantage™ - JSON Data Type, B035-1150
  • Teradata Vantage™ - XML Data Type, B035-1140
  • Teradata Vantage™ - SQL Functions, Expressions, and Predicates, B035-1145