Teradata Tutorial on Teradata Data Types
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 |