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