メインコンテンツまでスキップ

^ (caret sign) operator

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

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​

SQL
> SELECT 3 ^ 5;
6