Jump to navigation Jump to search
- where specifies the numeric value on which the bitwise NOT operation is performed.
- BITNOT() returns the result of a bitwise NOT operation performed on a numeric value.
- specifies the numeric value. If is not an integer, it is converted to an integer before its bits are shifted.
- The numeric value returned by BITNOT( ) represents with each bit of value 0 switched to 1 and each bit of value 1 switched to 0.
BITNOT(1) = -2 (Bit Not value of 'binary value 01' is '10' i.e -2.)
BITNOT(FALSE) = -1 (Bit Not value of 'binary value 00' is '11' i.e -1.)
- =BITNOT(TRUE) = -2
- =BITNOT(42) = -43
- =BITNOT((2+7)>8) = -2
- =BITNOT(0.5) = -1
- =BITNOT("d")= -1