DECIMAL data type

From InterBase
Jump to: navigation, search

Go Up to Fixed-decimal Data Types


DECIMAL(x,y)

In the syntax above, InterBase stores at least <x> digits. Of that number, exactly <y> digits are to the right of the decimal point. For example,

DECIMAL(5,2)

declares that a column of this type must be capable of holding at least five but possibly more digits and exactly two digits to the right of the decimal point: ppp.ss.