The Decimal data type defines a number that can contains a decimal part. The Decimal data type represents decimal numbers ranging from positive 79,228,162,514,264,337,593,543,950,335 to negative 79,228,162,514,264,337,593,543,950,335.

The integer and decimal parts must be separated by a dot ('.') and the maximum number of decimal digits stored in database is 8.

Use this type to store complex and large numbers, and when you must guarantee that there are no round-off errors. An example is for storing financial calculations.

When you don't need this extra precision, you should use the Integer type.

Default value

0.0

Examples

2004

204.56

-121.999

See Also

Built-in Mathematical Built-in Functions | Built-in Numeric Functions | About Null Values | About Decimal Literal | Available Data Types