Teradata Data Types

Each column in a table is associated with a data type. Data types simply denote the type of data that we can store in any particular column. For example, for storing string data like “James” into a column we need to define a column as char or varchar.

Whenever you are creating a table in Teradata, you need to define the data types of each column. You can choose datatypes as per your requirement.

Teradata Data Types

Following are some of the frequently used data types in Teradata.

Data Types Length (Bytes) Range of values
BYTEINT 1 -128 to +127
SMALLINT 2 -32768 to +32767
INTEGER 4 -2,147,483,648 to +2147,483,647
BIGINT 8 -9,233,372,036,854,775,80 8 to +9,233,372,036,854,775,8 07
DECIMAL 1-16  
NUMERIC 1-16  
FLOAT 8 IEEE format
CHAR Fixed Format 1-64,000
VARCHAR Variable 1-64,000
DATE 4 YYYYYMMDD
TIME 6 or 8 HHMMSS.nnnnnn or HHMMSS.nnnnnn+HHMM
TIMESTAMP 10 or 12 YYMMDDHHMMSS.nnnnnn or YYMMDDHHMMSS.nnnnnn +HHMM

Leave a Comment