NUMERIC data type

From InterBase
Jump to: navigation, search

Go Up to Fixed-decimal Data Types


NUMERIC(x,y)

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

NUMERIC(5,2)

declares that a column of this type always holds numbers with exactly five digits, with exactly two digits to the right of the decimal point: ppp.ss.