Teradata Data Type | Range | Transformation Data Type | Range |
|---|---|---|---|
Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | Bigint | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 Precision 19, scale 0 |
Byte | 1 to 64,000 bytes | Binary | 1 to 104,857,600 bytes |
Byteint | -128 to 127 | Integer | Precision 10, scale 0 |
Char | 1 to 64,000 bytes | String | 1 to 104,857,600 characters |
Date | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. Precision 19, scale 0 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Decimal | Precision 1 to 18, scale 0 to 18 | Decimal | Precision 1 to 28, scale 0 to 28 |
Float | -2.226E+308 to 1.797E+308 | Double | Precision 15 |
Integer | -2,147,483,648 to 2,147,483,647 | Integer | -2,147,483,648 to 2,147,483,647 Precision 10, scale 0 |
Smallint | -32768 to 32768 | Integer | Precision 10, scale 0 |
Time | 00:00:00.000000 to 23:59:61.999999 Precision 15, scale 6 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Timestamp | 1 to 19 characters Precision 19 to 26, scale 0 to 6 | Date/Time | Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond) |
Varbyte | 1 to 64,000 bytes | Binary | 1 to 104,857,600 bytes |
Varchar | 1 to 64,000 bytes | String | 1 to 104,857,600 characters |