꾸준히 mariaDB

[mariaDB] ROUND

써치킴 2022. 5. 19. 01:42

ROUND(숫자,반올림할 자릿수) 

 

숫자를 반올림할 자릿수 +1 자릿수에서 반올림
SELECT ROUND(3456.1234567) FROM DUAL
// 3456
 
SELECT ROUND(3456.1234567 ,1) FROM DUAL
// 3456.1
 
SELECT ROUND(3456.1234567 ,4) FROM DUAL
// 3456.1235
 
SELECT ROUND(3456.1234567 ,-1) FROM DUAL
// 3460
 
SELECT ROUND(3456.1234567 ,-2) FROM DUAL
// 3500