Getting the floor value of a number in SQLite?

You can just use cast it to an integer. It will truncate it, which is equivalent to floor.