Integer Numeric Data Types
| Data type | Size | From | To |
|---|---|---|---|
| SMALLINT | 2 bytes | -32768 | 32767 |
| INTEGER | 4 bytes | -2,147,483,648 | 2,147,483,647 |
| BIGINT | 8 bytes | -9223372036854775808 | 9223372036854775808 |
Approximate Numeric Data Types
| Data type | Size | From | To |
|---|---|---|---|
| REAL | 4 bytes | -3.40E + 38 | 3.40E + 38 |
| DOUBLE PRECISION | 8 bytes | -1.79E + 308 | 1.79E + 308 |
| FLOAT | -1.79E + 308 | 1.79E + 308 |
Exact Numeric Data Types
| Data type | From | To |
|---|---|---|
| DECIMAL | -10^38 +1 | 10^38 -1 |
| NUMERIC | -10^38 +1 | 10^38 -1 |