CODEWITHSUNDEEP
oracle-databaset-sql
Moggy
Moggy

Reputation: 171

How does Oracle's Bitwise operations work on decimal NUMBERS?

I am working on porting pl/sql to tsql and i am coming to BITAND operators working on NUMBERS such as 2.70703. How does oracle perform a bitwise operation on a NUMBER 2.70703? Is it converting it to the cloest binary number, rounding, truncating or something else? Tsql only takes integers. Thank you

Upvotes: 0

Views: 262

Answers (1)

Egor Skriptunoff
Egor Skriptunoff

Reputation: 23757

BITAND truncates operands toward zero and performs bit operation based on 2's complement 128-bit binary representation of integer values.

Upvotes: 1

Related Questions