Teradata 简明教程
Teradata - Data Types
表中的每一行都与数据类型相关联。数据类型指定将存储在该列中的值类型。Teradata 支持多种数据类型。以下是一些常用的数据类型。
Each column in a table is associated with a data type. Data types specify what kind of values will be stored in the column. Teradata supports several data types. Following are some of the frequently used data types.
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 |