在SQL中舍入到小数点后2位

本文介绍了在SQL中舍入到小数点后2位的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

每次我想四舍五入到小数点后两位时，它都不想四舍五入... 我怎么能将它四舍五入到小数点后两位零，这将给我92.00而不是92 ???

every time I want to round to 2 decimal places when it comes to zeros it doesnt want to round it... how could I round it to 2 decimal places with zeros at the end which would give me 92.00 instead of just 92 ???

SELECT ROUND(COLUMN_NAME,2) FROM ....

给我

COLUMN_NAME 92

但我想要

COLUMN_NAME 92.00

我使用了TO_CHAR，它起作用了

I used TO_CHAR and it worked

ROUND(TO_CHAR(COLUMN_NAME),2)

谢谢大家！

推荐答案

您可以尝试使用TO_CHAR函数转换结果

you may try the TO_CHAR function to convert the result

例如

SELECT TO_CHAR(92, '99.99') AS RES FROM DUAL SELECT TO_CHAR(92.258, '99.99') AS RES FROM DUAL

希望有帮助