Currency

Storage size

10 bytes

Keyable length

Up to 19

Static values

None

Function

Displays a value as a currency amount, with a currency symbol and thousands separator if specified in the data type’s format.

The currency value can be in the range [-99,999,999,999,999.99999 to 99,999,999,999,999.99999]. The decimal point is implied in the number, but not actually stored. For display purposes, currency values are limited to 14 digits to the left of the decimal and 5 digits to the right.

When specifying the keyable length for a currency value, note that all five decimal places must be accounted for. For instance, a currency value that will have the form $XXX.XX (two decimal places) will actually need to have a keyable length of 8 to account for the three additional decimal places that aren’t shown.


Documentation Feedback