Snowflake Functions
Bitwise Expression Functions
bitand
returns result of bitwise AND of integers x and y Supported Signatures
function bitand(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
bitnot
returns result of bitwise negation of integer x Supported Signatures
function bitnot(decimal(38, 0)) returns decimal(38, 0)
bitor
returns result of bitwise OR of integers x and y Supported Signatures
function bitor(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
bitshiftleft
returns result of arg1 bit-shifted left by arg2 bits Supported Signatures
function bitshiftleft(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
bitshiftright
returns result of arg1 bit-shifted right by arg2 bits Supported Signatures
function bitshiftright(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
bitxor
returns result of bitwise XOR of integers x and y Supported Signatures
function bitxor(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
getbit
returns result of the bit of base in specific bit index Supported Signatures
function getbit(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)