SIGN() - Sign of a Number
Q
How to get the sign of a given number using the SIGN() function?
✍: FYIcenter.com
A
SIGN(X) is a MySQL built-in function that
rounds the sign of X as -1, 0, or 1.
For example:
SELECT SIGN(-32), SIGN(0), SIGN(234); -- +-----------+---------+-----------+ -- | SIGN(-32) | SIGN(0) | SIGN(234) | -- +-----------+---------+-----------+ -- | -1 | 0 | 1 | -- +-----------+---------+-----------+
Reference information of the SIGN() function:
SIGN(X): int Returns the sign of the argument as -1, 0, or 1, depending on whether X is negative, zero, or positive. Arguments, return value and availability: X: Required. The input value. int: Return value. The integer representing the sign of X. Available since MySQL 4.0.
⇒ SIN() - Sine Trigonometric Value
⇐ ROUND() - Rounding to Decimal Place
2023-11-15, 1136🔥, 0💬
Related Topics:
