Query_Lang-SystemFunctions_Arithmetic_ROUNDROUND_AD
Created: 9月 05, 2015 | Updated: 8月 13, 2021
| Applies to versions: 15.1, 16.0, 16.1, 17.0, 17.1, 18.0, 18.1, 19.0, 19.1, 20.0, 20.1 and 20.2
現在、バージョン 17. をご覧頂いています。最新情報については、バージョン Query_Lang-SystemFunctions_Arithmetic_ROUND((ROUND))_AD の 21 をご覧ください。
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns an integral number, whose value depends upon the nature of the parameter's numeric value:
- If that numeric value is an exact integer, the number returned has exactly the same value.
- If that numeric value is not an exact integer, the number returned is the integer which is closest in value to the parameter's numeric value. Positive numbers which are exactly midway between adjacent integers are rounded upwards, while negative numbers which are exactly midway between adjacent integers are rounded downwards.
Syntax
ROUND(X : Number / Numeric_String) : Number
Example Usage
ROUND(5.0)
Returns 5.
ROUND(5.33)
Returns 5.
ROUND(5.5)
Returns 6 (Rounded upwards).
ROUND(5.66)
Returns 6.
ROUND(-5.0)
Returns -5.
ROUND(-5.33)
Returns -5.
ROUND(-5.5)
Returns -6 (Rounded downwards).
ROUND(-5.66)
Returns -6.