Am trying to execute " select floor(log (2,4)) result from dual " which should give the result as 2 but receiving wrong answer as could be seen below.
SQL> select floor(2) result from dual;
RESULT
----------
2
SQL> select log (2,4) result from dual;
RESULT
----------
2
SQL> select floor(log (2,4)) result from dual;
RESULT
----------
1
Am I doing something wrong?