最新历史版本
: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 |