The floor functions allows you to round down any number to the nearest integer.

For example:


would return 6


would return 7

See Ceil to round numbers up to the nearest integer.

See Round to round a number to a particular number of decimal places.

Floor – Oracle SQL Function
Tagged on: