Represents a decimal number of n digits, with m of those n digits to the right of the decimal point.
ANSI Compliance
NUMERIC is in the ANSI SQL:2011 standard. DECIMAL is a Teradata synonym for NUMERIC.
Syntax
{ DECIMAL | DEC | NUMERIC } [ ( n [, m ] ) ] [ attributes [...] ]
Syntax Elements
- n
- The precision (the maximum number of digits that can be stored).
- m
- The scale (the number of fractional digits).
- attributes
- Appropriate data type attributes, column storage attributes, or column constraint attributes.