Query_Lang-SystemFunctions_Arithmetic_SIGNSIGN_AD
Created: 九月 05, 2015 | Updated: 八月 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
您正在阅读的是 20. 版本。关于最新版本,请前往 Query_Lang-SystemFunctions_Arithmetic_SIGN((SIGN))_AD 阅读 21 版本
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns sign value of the supplied parameter. That is, it returns an integral number, whose value depends upon the nature of the parameter's numeric value:
- If that numeric value is positive, the number returned is 1.
- If that numeric value is negative, the number returned is -1.
- If that numeric value is exactly zero, the number returned is 0.
Syntax
SIGN(X : Number / Numeric_String) : Number
Example Usage
SIGN(5.33)
Returns 1.
SIGN(-5.33)
Returns -1.
SIGN(0)
Returns 0.