General MySQL Oracle SQL Server

FLOOR() - Flooring a Numeric Value

Q

How to floor a numeric value to an integer using the FLOOR() function?

✍: FYIcenter.com

A

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

⇑ MySQL Functions on Numeric Values

⇑⇑ MySQL Function References

2023-12-19, 1610🔥, 0💬

General MySQL Oracle SQL Server