Money data types
Synopsis
The MONEY
data type represents currency with a fixed precision for fraction.
Data type | Description | Min | Max |
---|---|---|---|
MONEY | 8 bytes | -92233720368547758.08 | +92233720368547758.07 |
Description
type_specification ::= MONEY
To avoid precision loss, MONEY
value can be cast to NUMERIC
type before applying calculations.