Column Data Type | Teradata Studio - Column Data Type - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
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