Provide the sign of a number.
| SELECT SIGN(255.5); |
The SIGN() function retrieves the numerical sign of a given number.
The SIGN() function yields:
| SIGN(number) |
|
Parameter |
Description |
|
number |
Necessary: The numerical value for which the sign needs to be determined |
|
Works in: |
From MySQL version 4.0 |
Determine the sign of a given number.
| SELECT SIGN(-12); |