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