v2025.1 STS Stable release with standard-term support v2.25 Preview Preview release - not for production v2024.2 LTS Stable release with long-term support v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support Unsupported versions

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.