SQL ReferenceSQL FunctionsNumeric FunctionsFLOOROn this pageFLOORCopy PageRounds the number down. Syntax FLOOR( <x> ) Examples SELECT FLOOR(1.23);┌─────────────┐│ floor(1.23) │├─────────────┤│ 1 │└─────────────┘