| Informix Guide to SQL: Syntax Segments |
|
|
A literal number is an integer or noninteger (floating) constant. Use the Literal Number segment whenever you see a reference to a literal number in a syntax diagram.
|
| Element | Purpose | Restrictions | Syntax |
|---|---|---|---|
| digit | Digit that forms part of the literal number | You must specify a value between 0 and 9, inclusive. | Digits are literal values that you enter from the keyboard. |
Literal numbers do not contain embedded commas; you cannot use a comma to indicate a decimal point. You can precede literal numbers with a plus or a minus sign.
Integers do not contain decimal points. The following examples show some integers:
Floating and decimal numbers contain a decimal point and/or exponential notation. The following examples show floating and decimal numbers:
The digits to the right of the decimal point in these examples are the decimal portions of the numbers.
The E that occurs in two of the examples is the symbol for exponential notation. The digit that follows E is the value of the exponent. For example, the number 3E5 (or 3E+5) means 3 multiplied by 10 to the fifth power, and the number 3E-5 means 3 multiplied by 10 to the minus fifth power.
When you use a literal number as a MONEY value, do not precede it with a money symbol or include commas.
For discussions of numeric data types, such as DECIMAL, FLOAT, INTEGER, and MONEY, see the Informix Guide to SQL: Reference.