^ (caret sign) operator (Databricks SQL)

Returns the bitwise exclusive OR (XOR) of expr1 and expr2.

Syntax

expr1 ^ expr2

Arguments

  • expr1: An integral numeric type expression.

  • expr2: An integral numeric type expression.

Returns

The result type matches the least common type of expr1 and expr2.

Examples

> SELECT 3 ^ 5;
 6