16.00 - Column Data Type - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
Data Type Description
BINARY LARGE OBJECT Large binary string of raw bytes
BYTE Fixed length binary string
BYTEINT Signed binary integer value in the range of -128 to 127.
CHARACTER Fixed length character string
CHARACTER LARGE OBJECT Large character string
DATASET Complex data type (CDT) representing self-describing files that are interpreted based on a schema
DATE Date consisting of year/month/day
DECIMAL Decimal number with fixed number of digits and a fixed number of digits to the right of the decimal point
FLOAT Floating point number
INTEGER 32-bit binary integer
INTERVAL DAY An interval defining a period of time in days
INTERVAL DAY TO HOUR An interval defining a period of time in days and hours
INTERVAL DAY TO MINUTE An interval defining a period of time in days, hours and minutes
INTERVAL DAY TO SECOND An interval defining a period of time in days, hours, minutes and seconds
INTERVAL HOUR An interval defining a period of time in hours
INTERVAL HOUR TO MINUTE An interval defining a period of time in hours and minutes
INTERVAL HOUR TO SECOND An interval defining a period of time in hours, minutes and seconds
INTERVAL MINUTE An interval defining a period of time in minutes
INTERVAL MINUTE TO SECOND An interval defining a period of time in minutes and seconds
INTERVAL MONTH An interval defining a period of time in months
INTERVAL SECOND An interval defining a period of time in seconds
INTERVAL YEAR An interval defining a period of time in years
INTERVAL YEAR TO MONTH An interval defining a period of time in years and months d seconds
JSON (JavaScript Object Notation) text-based, data interchange format used in web applications to transmit data
NUMBER A numeric value with optional precision and scale limitations
PERIOD(DATE) A period of dates consisting of year/month/day. (This type is available only for Teradata 13 and later.)
PERIOD(TIME) A period of times consisting of hour/minute/second/fractional second. (This type is available only for Teradata 13 and later.)
PERIOD(TIME WITH TIME ZONE) A period timestamp with displacements from UTC. (This type is available only for Teradata 13 and later.)
PERIOD(TIMESTAMP) A period of timestamps consisting of year/month/day/hour/minute/second/fractional second. (This type is available only for Teradata 13 and later.)
PERIOD(TIMESTAMP WITH TIME ZONE) A period of timestamps with displacements from UTC. (This type is available only for Teradata 13 and later.)
SMALLINT 16-bit binary integer
ST_GEOMETRY Used for creating and manipulating geometric shapes in the database
TIME A time consisting of hour/minute/second/fractional second
TIME WITH TIME ZONE A time with a displacement from UTC
TIMESTAMP A timestamp consisting of year/month/day/hour/minute/second/fractional second
TIMESTAMP WITH TIME ZONE A timestamp with a displacement from UTC
User-defined Type A user-defined type (udt). This option appears only for systems that support user-defined types.
VARBYTE Variable length binary string
VARCHAR Variable length character string
XML (Extensible Markup Language) text-based, data format used for application integration to format messages passed between applications and as a document format for storing data