Collections:
MySQL Functions on Numeric Values
Where to find reference information and tutorials on MySQL database functions on numeric values? I want to know how to use ABS(), ROUND() and other numeric value functions.
✍: FYIcenter.com
Here is a collection of reference information and tutorials on MySQL database functions on numeric values compiled by FYIcenter.com DBA team.
ACOS() - Arccosine Trigonometric Value
ASIN() - Arcsine Trigonometric Value
ATAN() - Arctangent Trigonometric Value
ATAN2() - 2-Argument Arctangent
BIN() - Converting Integer to Binary String
BIT_COUNT() - Counting '1' in Binary String
CEIL() - Synonym for CEILING()
CEILING() - Rounding up to Integer
CONV() - Number Base Conversion
COS() - Cosine Trigonometric Value
COT() - Cotangent Trigonometric Value
DEGREES() - Radians to Degrees
FLOOR() - Flooring a Numeric Value
FORMAT() - Formatting Number to String
FORMAT_BYTES() - Formatting Bytes in Readable Units
EXP() - Exponential Based on E
EXPORT_SET() - Exporting Binary Set to On/Off Flags
INTERVAL() - Interval Position of Sorted List
LOG() - Logarithm of Y to Base X
LOG10() - Logarithm to Base 10
MAKE_SET() - Filtering List with Binary Set
MOD() - Remainder of X divided by Y
POW() - X Raised to Power of Y
RADIANS() - Degrees to Radians
RAND() - Random Value Generator
ROUND() - Rounding to Decimal Place
SIN() - Sine Trigonometric Value
2023-11-14, 266🔥, 0💬
Popular Posts:
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...