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.

Comments are closed.

Sorry, the comment form is closed at this time.