+-------------------+
1 row in set
示例3:D 为“0”,返回值不包含小数点和小数部分。
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
767
gbase> SELECT TRUNCATE(1.999,0) FROM dual;
+-------------------+
| TRUNCATE(1.999,0) |
+-------------------+
|
1 |
+-------------------+
1 row in set
示例4:X 为“-1.999”,小数点后保留一位。
gbase> SELECT TRUNCATE(-1.999,1) FROM dual;
+--------------------+
| TRUNCATE(-1.999,1) |
+--------------------+
|
-1.9 |
+--------------------+
1 row in set
示例5:D 为-2,个位十位归零。
gbase> SELECT TRUNCATE(122,-2) FROM dual;
+------------------+
| TRUNCATE(122,-2) |
+------------------+
|
100 |
+------------------+
1 row in set
示例6:X 为表达式。
gbase> SELECT TRUNCATE(10.28*100,0) FROM dual;
+-----------------------+
| TRUNCATE(10.28*100,0) |
+-----------------------+
|
1028 |
+-----------------------+
1 row in set