MONEY data types

Synopsis

The MONEY data type represents currency with a fixed precision for fraction.

Data typeDescriptionMinMax
MONEY8 bytes-92233720368547758.08+92233720368547758.07

Description

  1. type_specification ::= MONEY

To avoid precision loss, MONEY value can be cast to NUMERIC type before applying calculations.