General MySQL Oracle SQL Server

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

⇑ MySQL Functions on Numeric Values

⇑⇑ MySQL Function References

2023-11-15, 1608🔥, 0💬

General MySQL Oracle SQL Server