Exact numeric types are used when you wish to store a numeric value in its exact representation without accumulating rounding errors. Specifically, NUMERIC and DECIMAL types allow you to specify the scale so that any numeric values with a greater scale are automatically rounded to the specified scale using the bankers rounding algorithm, which simply says that any digits past the specified scale are rounded to the specified scale using the following logic:

1) Round towards the nearest integer.

2) If there are two nearest integers, then round the value towards the even integer value.


Literals

---

Exact numeric literals use the period (.) as the decimal point character, the minus (-) as the negative sign character, the plus (+) as the positive sign character, and scientific notation is not supported.

Literal Examples

---

-- This example specifies an INTEGER literal

SELECT * FROM Customer WHERE CustNo=1206

-- This example specifies a DECIMAL literal

SELECT * FROM Customer WHERE BalanceDue > 1000.00

SQL 2003 Standard Deviations

---

The following areas are where ElevateDB deviates from the SQL 2003 standard: