What is the function of the floor function in MySQL?

Tag: color equals mysq nbsp Large integer PNG return tag string

Requirements Description :

Recently, when I wrote the MySQL program, I used the floor function, where the function was recorded.

Operation Process :

1. Testing using the floor function

Mysql> Select Floor (1.23), Floor ( -1.23), +-------------+--------------+| Floor (1.23) | Floor ( -1.23) |+-------------+--------------+|           1 |           -2 |+-------------+--------------+1 row in Set (0.00 sec)

Note: According to the official documentation, the floor function returns the largest integer less than or equal to the value.

:

Official documentation Reference :

Floor (X) Returns the largest integer value is not greater than x.mysql> SELECT floor (1.23), floor ( -1.23);        --1, 2
for string or floating-point arguments, the return value has a floating-point type.  Note: The part labeled yellow has not been fully understood.

Document creation time: June 26, 2018 13:19:04

What is the function of the floor function in MySQL?