~
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Operators for MariaDB Enterprise Server
Topics on this page:
Overview
Bitwise not.
EXAMPLES
SELECT HEX(~7), HEX(~32767), HEX(~0);
+------------------+------------------+------------------+
| HEX(~7) | HEX(~32767) | HEX(~0) |
+------------------+------------------+------------------+
| FFFFFFFFFFFFFFF8 | FFFFFFFFFFFF8000 | FFFFFFFFFFFFFFFF |
+------------------+------------------+------------------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.