FLOOR: return the largest integer less than the given value
1> -- FLOOR: return the largest integer less than the given value. 2> 3> SELECT FLOOR(-145.677) 4> GO -------- -146 (1 rows affected)