MySQL舍入函数 [英] MySQL Rounding functions
本文介绍了MySQL舍入函数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在寻找一种ROUND()
类型的函数,该函数可以让我将数字四舍五入到小数点后1位,也可以四舍五入到最接近的0.5.
I am looking for a ROUND()
type function that would allow me to round numbers to 1 decimal place but also to the nearest 0.5.
说明:
19.425 => 19.5
19.124 => 19.0
类似地:
12.654 => 12.5
12.845 => 13.0
推荐答案
正如vissi所说,要获得结果,您需要2个舍入语句. (到小数点后一位)
As vissi said, to get the result you want you'll need 2 round statements. (To get to 1 decimal place)
SELECT ROUND(ROUND(19.425 * 2) / 2, 1) #19.5
SELECT ROUND(ROUND(19.124 * 2) / 2, 1) #19.0
SELECT ROUND(ROUND(12.654 * 2) / 2, 1) #12.5
SELECT ROUND(ROUND(12.845 * 2) / 2, 1) #13.0
这篇关于MySQL舍入函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文