Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

MONETARY

Description

The MONETARY data type is an approximate numeric data type. The range of valid value is the same as DOUBLE, which is represented to two decimal places; the value range can be different based on system. A comma is appended to every 1000th place.

MONETARY

Remark

You can use a dollar sign or a decimal point, but a comma is not allowed.

Example

If you specify 12345.67898934 as MONETARY, $12,345.68 is stored (it is rounded to third decimal place).

If you specify 123456789 as MONETARY, $123,456.789.00 is stored.