Mysql 숫자함수 (ABS, CEILING, FLOOR, ROUND, TRUNCATE)

1. ABS (절대값) : 

   • SELECT ABS(123) FROM DUAL
     -- 123
      
     SELECT ABS(-10) FROM DUAL
     -- 10

2. ROUND (반올림)

   • SELECT ROUND(1234.56789) FROM DUAL
     -- 1235
      
     SELECT ROUND(1234.56789 ,1) FROM DUAL
     -- 1234.6
      
     SELECT ROUND(1234.56789 ,4) FROM DUAL
     -- 1234.5679
      
     SELECT ROUND(1234.56789 ,-1) FROM DUAL
     -- 1230
      
     SELECT ROUND(1234.56789 ,-2) FROM DUAL
     -- 1200

3. CEILING (올림)

   • SELECT CEILING(12.34) FROM DUAL
     -- 13
      
     SELECT CEILING(12.99 ,1) FROM DUAL
     -- 13
      
     SELECT CEILING(56.0) FROM DUAL
     -- 56
      
     SELECT CEILING(19.1) FROM DUAL
     -- 20
      
     SELECT CEILING(-19.1) FROM DUAL
     -- -19

4. FLOOR (내림)

   • SELECT FLOOR(12.34) FROM DUAL
     -- 12
      
     SELECT FLOOR(19.0) FROM DUAL
     -- 19
      
     SELECT FLOOR(-19.1) FROM DUAL
     -- -20

5. TRUNCATE (소수점 버림)

   • SELECT TRUNCATE(1234.56789 ,1) FROM DUAL;
     -- 1234.5
      
     SELECT TRUNCATE(1234.56789 ,4) FROM DUAL;
     -- 1234.5678
      
     SELECT TRUNCATE(1234.56789 ,-1) FROM DUAL;
     -- 1230
      
     SELECT TRUNCATE(1234.56789 ,-2) FROM DUAL;
     -- 1200

 

 

 

---

 Ref.

Mysql/Mariadb 숫자함수 (ABS, CEILING, FLOOR, ROUND, TRUNCATE)

[MySQL] 반올림과 버림 함수 - ROUND(), TRUNCATE()