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, 198🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...