Numeric functions (Rounding and Truncation)
Returns the sign of its argument:
-1 if the argument is negative.
1 if it is positive.
0 if it is 0.
SIGN( <expr> )
Copy
Examples¶SELECT SIGN(5), SIGN(-1.35e-10), SIGN(0); ---------+-----------------+---------+ SIGN(5) | SIGN(-1.35E-10) | SIGN(0) | ---------+-----------------+---------+ 1 | -1 | 0 | ---------+-----------------+---------+
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4