BINARY LARGE OBJECT |
Large binary string of raw bytes |
BYTE |
Fixed length binary string |
CHARACTER |
Fixed length character string |
CHARACTER LARGE OBJECT |
Large character string |
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 |
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 |
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 |