Money data types
This page documents the preview version (v2.23). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.
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.