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 |