Collections:
FLOOR() - Flooring a Numeric Value
How to floor a numeric value to an integer using the FLOOR() function?
✍: FYIcenter.com
FLOOR(num) is a MySQL built-in function that returns the largest integer value not greater than the given numeric value. For example:
SELECT FLOOR(1.23), FLOOR(-1.23); -- +-------------+--------------+ -- | FLOOR(1.23) | FLOOR(-1.23) | -- +-------------+--------------+ -- | 1 | -2 | -- +-------------+--------------+
Reference information of the FLOOR() function:
FLOOR(num): int Returns the largest integer value not greater than the given numeric value. Arguments, return value and availability: num: Required. The numeric value to be converted. int: Return value. The converted integer. Available since MySQL 4.0.
⇒ FORMAT() - Formatting Number to String
⇐ DEGREES() - Radians to Degrees
2023-12-19, 202🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...