Query_Lang-SystemFunctions_Arithmetic_INTINT_AD
Created: сентября 05, 2015 | Updated: августа 13, 2021
| Applies to versions: 1.0, 1.1, 2.0, 2.1, 3.0, 3.1 and 3.2
Вы просматриваете версию 1.1. Для самой новой информации, перейдите на страницу Query_Lang-SystemFunctions_Arithmetic_INT((INT))_AD для версии 4
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 positive but is not an exact integer, the number returned is the largest integer that is smaller in value than the parameter's numeric value.
- If that numeric value is negative but is not an exact integer, the number returned is the smallest integer that is larger in value than the parameter's numeric value.
- If that numeric value is an exact integer, the number returned has exactly the same value.
Syntax
INT(X : Number / Numeric_String) : Number
Example Usage
INT(5.0)
Returns 5.
INT(5.33)
Returns 5.
INT(-5.0)
Returns -5.
INT(-5.33)
Returns -5.
Tips
- This is an alias for the TRUNC arithmetic function.