December 11th, 2008
FLOOR (round downward)
Posted by
admin in
H. ANSI Numeric Scalar Functions
he FLOOR function returns the largest integer less than the input value.
Format:Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â FLOOR(expression)
Example: SELECT FLOOR(10.8) FROM TABLEA;
Result:
                   
>DB2, MySQL, Oracle, and SQL Server support FLOOR.
> Access, PostgreSQL, and Sybase don’t support FLOOR.
Â
