3. Understanding SQL Data Types : Literals : Numeric Literals : Decimal Literals
 
Share this page                  
Decimal Literals
Decimal literals are specified as signed or unsigned numbers of 1 to 39 digits that include a decimal point. The precision of a decimal number is the total number of digits, including leading and trailing zeros. The scale of a decimal literal is the total number of digits to the right of the decimal point, including trailing zeros.
Decimal literals that exceed 39 digits are treated as floating point values.
Examples of decimal literals are:
3.
-10.
1234567890.12345
001.100