Bitand Question

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 - 15:53:53 CST