Truncates a number at a specified number of places after the decimal point.
Parameter |
Description |
---|---|
numeric-expression |
The number to be truncated. |
integer-expression |
A positive integer specifies the number of significant digits to the right of the decimal point at which to round. A negative expression specifies the number of significant digits to the left of the decimal point at which to round. |
NUMERIC
This function is the same as TRUNCATE, but does not cause keyword conflicts.
You can use combinations of ROUND, FLOOR, and CEILING to provide similar functionality.