Re: Odd math

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/07/12
Message-ID: <396C7A73.4117@yahoo.com>#1/1

Steve Adams wrote:
>
> 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/

You can group this with odd dates (in 8.1.5)

select

  to_date('01JAN2000','ddmmyyyy')
  to_date('01JAN2000','dd/mm/yyyy'),
  to_date('01JAN2000','dd-mon-yyyy')

from dual

all work .... Hmmmmmmm

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Wed Jul 12 2000 - 00:00:00 CDT