跳到主要内容
跳到主要内容

round_bankers

round_bankers

description

Syntax

T round_bankers(T x[, d])x使用银行家舍入法后,保留d位小数,d默认为0。如果d为负数,则小数点左边d位为0。如果xd为null,返回null。

  • 如果舍入数介于两个数字之间,则该函数使用银行家的舍入
  • 在其他情况下,该函数将数字四舍五入到最接近的整数。

example

mysql> select round_bankers(0.4);
+--------------------+
| round_bankers(0.4) |
+--------------------+
| 0 |
+--------------------+
mysql> select round_bankers(-3.5);
+---------------------+
| round_bankers(-3.5) |
+---------------------+
| -4 |
+---------------------+
mysql> select round_bankers(-3.4);
+---------------------+
| round_bankers(-3.4) |
+---------------------+
| -3 |
+---------------------+
mysql> select round_bankers(10.755, 2);
+--------------------------+
| round_bankers(10.755, 2) |
+--------------------------+
| 10.76 |
+--------------------------+
mysql> select round_bankers(1667.2725, 2);
+-----------------------------+
| round_bankers(1667.2725, 2) |
+-----------------------------+
| 1667.27 |
+-----------------------------+
mysql> select round_bankers(1667.2725, -2);
+------------------------------+
| round_bankers(1667.2725, -2) |
+------------------------------+
| 1700 |
+------------------------------+

keywords

round_bankers