| 14.12.FLOOR | ||||
| 14.12.1. | FLOOR(x) gets the largest integer less than or equal to x. | |||
| 14.12.2. | Use FLOOR function to get the flooring value | |||
| 14.12.3. | FLOOR for negative value | |||
| 14.12.4. | FLOOR(5.8) | |||
| 14.12.5. | FLOOR(-5.2) | |||
| 14.12.6. | select round(345.678), ceil(345.678), floor(345.678) | |||
| 14.12.7. | Use floor to get the number of weeks | |||
| 14.12.8. | Use floor and mod to get the number of days | |||