16.20 - Example: Querying the BITAND Operation On An INTEGER - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2020-03-25
dita:mapPath
xzf1512079057909.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
kby1472250656485

The following query performs the BITAND operation on an INTEGER and a single-byte hexadecimal byte literal.

   SELECT BITAND(287454020, 'FFFF'XB);

The INTEGER value 287,454,020 has a hexadecimal value of 0x11223344 and a bit numbering representation of:



The hexadecimal byte literal 0xFFFF has a bit numbering representation of:



To process the BITAND operation, the two arguments are aligned on their least significant byte/bit as follows:





The shorter-length hexadecimal byte literal 0xFFFF is padded with zeros to the left until it is the same length as the INTEGER value 287,454,020.





When both operands are the same size, the BITAND operation is performed, producing the following result: