วิธี Round ตัวเลขทศนิยม เมื่อใช้ Microsoft SQL Server
ตัวอย่าง
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
DECLARE @digi float; DECLARE @val decimal(18,6); SET @digi=3 SET @val =3214.002734 SELECT 1 As EXAMPLE, @val AS VALUE ,'DEFAULT' AS REMARK union SELECT 2 As EXAMPLE, CEILING(@val*(POWER(10,@digi)))/POWER(10,@digi) AS VALUE , 'ROUNDUP' AS REMARK union SELECT 3 As EXAMPLE, FLOOR(@val*(POWER(10,@digi)))/POWER(10,@digi) AS VALUE ,'ROUNDDOWN' AS REMARK union SELECT 4 AS EXAMPLE, ROUND(@val,@digi) AS VALUE , 'ROUND5UP' AS REMARK ORDER BY EXAMPLE |
ผลลัพธ์

การ Round ตัวเลขใน Microsoft SQL Server
0 Comments