Bitand Question
From: Terry Coccoli <request_at_ifneeded.com>
Date: Fri, 05 Mar 2004 21:53:53 GMT
Message-ID: <NF62c.1815811$9p3.336297_at_news.easynews.com>
Date: Fri, 05 Mar 2004 21:53:53 GMT
Message-ID: <NF62c.1815811$9p3.336297_at_news.easynews.com>
Can someone tell me if the following query:
select bitand(power(2,31),power(2,30))+0
from dual
which returns 1073741824 is correct ? I'm thinking that the result
should actually be 0.
When I run
select bitand(power(2,30),power(2,29))+0
from dual
I get 0, as expected. Am I running into a limitation of the bitand
function ? Is there any documentation on this function?
Thanks.
Received on Fri Mar 05 2004 - 22:53:53 CET