Teradata 中的一些基本数据类型列表如下—：

数据类型    长度 (Bytes)    值范围
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+HHMM or HHMMSS.nnnnnn
CHAR    Fixed Format    1-64,000
TIMESTAMP    10 or 12    YYMMDDHHMMSS.nnnnnn +HHMM or YYMMDDHHMMSS.nnnnnn