[MySQL] mysql 소수점 처리

 

반올림 - ROUND()

SELECT ROUND(2.73) AS RESULT FROM DUAL;

RESULT

3

 

소수점 자르기 - TRUNCATE()

SELECT TRUNCATE(2.73, 0) AS RESULT FROM DUAL;

RESULT

2

 

소수점 표시 - ROUND(number, decimals)

SELECT ROUND(2.73, 1) AS RESULT FROM DUAL;

RESULT

2.7

 

 

---

 

메모

MySQL ROUND() Function

 

Syntax

ROUND(number, decimals)

 

Parameter Values

ParameterDescription

number	Required. The number to be rounded
decimals	Optional. The number of decimal places to round number to. If omitted, it returns the integer (no decimals)

 

 

MySQL TRUNCATE() Function

 

Syntax

TRUNCATE(number, decimals)

 

Parameter Values

ParameterDescription

number	Required. The number to be truncated
decimals	Required. The number of decimal places to truncate to