Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

The Oracle FLOOR Function [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: FLOOR

Definition:
The FLOOR function rounds a number down to the next higher integer. If number is already rounded, it simply returns the number unchanged.

Example Syntax:

FLOOR(number)

Example Usage:

FLOOR(556.873) - returns "556"



FLOOR(43.9)    - returns "43"



FLOOR(-27.8)   - returns "-28"

Related Links:

Oracle Numeric Functions: FLOOR
Oracle Numeric Functions: CEIL

Related Code Snippets:

Floor - Returns the largest integer not greater than argument.

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

PSOUG LOGIN
Username:
Password: