Re: Odd math

From: Yong <yhuang_at_slb.com>
Date: 2000/07/12
Message-ID: <8kide9$oa3$1@news.sinet.slb.com>#1/1

I'm using 8.1.5 on Solaris. It's the same:

SQL> select trunc(log(2,4)) from dual;

TRUNC(LOG(2,4))

---

              1

SQL> select * from v$version;

BANNER

---

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production PL/SQL Release 8.1.5.0.0 - Production
CORE Version 8.1.3.0.0 - Production
TNS for Solaris: Version 8.1.5.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

I'll try this on 8.0.5 tonight.

Yong Huang

Steve Adams <steve.adams_at_ixora.com.au> wrote in message news:396befcf.127433039_at_news.eagles.bbs.net.au...
> Hi All,
>
> Oracle 8.1.6 appears to think that ... trunc(log(2, 4)) = 1.
>
> SQL> select trunc(log(2,4)) from dual;
>
> TRUNC(LOG(2,4))
> ---------------
> 1
>
> Does it reproduce on earlier versions?
> Any comments?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
Received on Wed Jul 12 2000 - 00:00:00 CDT