MSSQL 반올림, 자르기(절삭), 올림, 내림

---------------------------------------------- 
-- 반올림 
-- 함수 : ROUND ( numeric_expression, length [, function])
----------------------------------------------
DECLARE @AAA DECIMAL(16,5) = 12.35393
SELECT ROUND(@AAA,2)  
--> 결과값 : 12.35000
 
SELECT ROUND(@AAA,2)  
--> 결과값 : 12.35000

SELECT ROUND(@AAA,-1)  
--> 결과값 : 10.00000

SELECT ROUND(@AAA,-1)  
--> 결과값 : 10.00000

SELECT ROUND(@AAA,0)  
--> 결과값 : 12.00000
 
 

---------------------------------------------- 
-- 자르기 
---------------------------------------------- 
SELECT ROUND(@AAA, 1, 1) 
--> 결과값 : 12.30000

SELECT ROUND(@AAA, 0, 1) 
--> 결과값 : 12.00000

SELECT ROUND(@AAA, -1, 1) 
--> 결과값 : 10.00000

 

 

---------------------------------------------- 
-- 올림 
-- 함수 : CEILING ( numeric_expression )
----------------------------------------------
SELECT CEILING(@AAA)
--> 결과값 : 13 

SELECT CEILING(-@AAA)
--> 결과값 : -12 

SELECT CEILING(0.00)  
--> 결과값 : 0 

 

 

---------------------------------------------- 
-- 내림 
-- 함수 : FLOOR ( numeric_expression )
---------------------------------------------- 
SELECT FLOOR(@AAA)  
--> 결과값 : 12 

SELECT FLOOR(-@AAA)  
--> 결과값 : -13 

SELECT FLOOR(0.00)  
--> 결과값 : 0