FLOOR
The function FLOOR returns the largest integer for the numeric expression.
| SQL Syntax: |
FLOOR( number ) | |
| Number: |
Any numeric expression. | |
| Escape Syntax: |
{fn FLOOR( number )} | |
| Return Type: |
FLOAT | |
Examples:
SELECT FLOOR(1.3), {fn floor(-0.5)}
see also:
SQL Numeric Functions
ROUND
TRUNCATE