历史版本3 :TRUNC-返回指定位数 返回文档
编辑时间:
内容长度:图片数:目录数:
修改原因:
1. Overview编辑
grammar | TRUNC(number,num_digits) | Truncates a number by a certain number of digits and returns an integer or decimal. |
---|---|---|
parameter1 | number | The number that needs to be truncated and rounded. |
parameter2 | num_digits | The number used to specify the rounding precision. |
2. Matters needing attention编辑
Two numeric parameters are supported, the second one can be defaulted
3. Examples编辑
Formula | Result | Remark |
---|---|---|
TRUNC(8.9) | 8 | |
TRUNC(-8.9) | -8 | |
TRUNC(-8.98,1) | -8.9 | |
TRUNC(PI()) | 3 |