Collections:
SIGN() - Sign of a Number
How to get the sign of a given number using the SIGN() function?
✍: FYIcenter.com
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, 244🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...