FLOOR

Rounds the number down.

Syntax

FLOOR( <x> )

Examples

SELECT FLOOR(1.23);

┌─────────────┐
│ floor(1.23) │
├─────────────┤
│           1 │
└─────────────┘