16.20 - Examples: Querying with the BITAND Function - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

Passing a BYTEINT Value to BITAND

In the following query, the input argument 23 has a data type of BYTEINT and a binary representation of 00010111. The input argument 20 has a data type of BYTEINT and a binary representation of 00010100. The bitwise AND product of the two arguments results in a BYTEINT value of 20, or binary 00010100, which is returned by the query.

   SELECT BITAND(23,20);

Passing a NUMBER Value to BITAND

SELECT BITAND( CAST('A593C38281B4D2E1'XI8 AS NUMBER), 'FFFFFFFFFFFFFFFF'xb);

Result:

BITAND(-6515649270585699615,'FFFFFFFFFFFFFFFF'XB)
-------------------------------------------------
                             -6515649270585699615
SELECT TO_BYTE( CAST( BITAND( CAST('5A393C28184B2D1E'XI8 AS NUMBER), '0000FFFFFFFFFFFF'xb) AS BIGINT ));

Result:

TO_BYTE(BITAND(6501293679989959966,'0000FFFFFFFFFFFF'XB))
---------------------------------------------------------
00003C28184B2D1E