Difference between 'Number' and 'Integer'

Database

Difference between 'Number' and 'Integer'

Can anyone please let me know what is the differenc between 'Number' and 'Integer' in Teradata?

Thanks,

Kumar

Tags (2)
1 REPLY

Re: Difference between 'Number' and 'Integer'

INTEGER is a 32-bit binary numeric type.  It has a fixed storage size of 4 bytes.

NUMBER is a new data type, introduced in Teradata 14.0, which is intended to emulate the Oracle number data type. It has an optional precision and scale of up to 38 decimal digits.  It can also represent exponential values. Its storage size varies from 0 to 18 bytes.