The DECIMAL/NUMERIC data type is an Exact numeric type datatype

Declaration


DECIMAL | NUMERIC [ ( precisionVal [, scaleVal ] ) ]

Arguments

  • precisionVal

  • scaleVal

Numeric Type

  • Exact

Storage Size

  • Dependent on the declared size.

Value Range

  • precisionVal: Total number of digits in the value, from both the left and right of the decimal. Must be between 1 and 31. Defaults to 5.

  • scaleVal: The number of digits to the right of the decimal. Cannot be greater than precisionVal. Defaults to 0.

Examples


DECIMAL(10, 2)
1356.76

DECIMAL()
13786