Round (X[,y]) "Function" returns the rounded value
Parameter x,y, numeric expression, if Y is not an integer, intercepts the y-integer portion, if y>0 is rounded to Y-decimal, and if Y is less than 0, rounded to the decimal point to the left.
"Back" number
"Example" Select Round (5555.6666,2.1), round (5555.6666,-2.6), round (5555.6666) from dual;
Back: 5555.67, 5600, 5556
"Close" trunc (X[,y]) returns the intercepted value, using the same round (X[,y]), just not rounded
Trunc (X[,y]) "Function" returns the value of x intercepted by Precision Y
"Parameter" x,y, numeric expression, if Y is not an integer, the y-integer section is intercepted, if Y>0 is intercepted to Y-decimal, if Y is less than 0, then the decimal point is truncated to the left, and the other data is expressed in 0.
"Back" number
"Example" select Trunc (5555.66666,2.1), trunc (5555.66666,-2.6), Trunc (5555.033333) from dual;
Back: 5555.66 5500 5555
"Close" round (X[,y]) returns the intercepted value, using the same trunc (X[,y]), just to do rounding
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.