|
|
|
|
|
|
The TRUNCATE Function
Syntax for the TRUNCATE function:
numeric-value is an integer or a float value expression.
integer-value is an integer value expression.
Rules:
- If integer-value is positive, the value describes the number of digits permitted in numeric-value, after truncation, to the right of the decimal point.
If it is negative, it describes the number of digits allowed to the left of the decimal point.
- The value returned depends on the data type of numeric-value.
- If the value of either operand is NULL, then the result of the function is NULL.
 Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se |
|
|
|
|
|
|
