함수 floor()

Round fractions down

1 EXCEL

=INT(3.14159)
// returns 3

=INT(-3.14159)
// returns -4

=INT(9.98)
// returns 9

=FLOOR(3.14159, 1)
// returns 3

=FLOOR(-3.14159, -1)
// returns -3

=FLOOR(9.98, 1)
// returns 9

2 JavaScript

console.log( Math.floor(10.6) ); // 10

3 PHP

float floor ( float $value );

echo floor(3.14159);   // 3
echo floor(-3.14159); // -4
echo floor(9.98); // 9

4 SQL

4.1 Oracle

SELECT FLOOR(12.3456) FROM DUAL;
-- returns 12

SELECT FLOOR(-12.3456) FROM DUAL;
-- returns -13

SELECT TRUNC(12.3456) FROM DUAL;
-- returns 12

SELECT TRUNC(-12.3456) FROM DUAL;
-- retruns -12

5 See also

• round
• ceil