Cast Functions Operators MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Cast Functions Operators
  4. SELECT CAST(1 AS UNSIGNED) - 2 0
mysql>
mysql> SELECT CAST(1 AS UNSIGNED) - 2.0;
+---------------------------+
| CAST(1 AS UNSIGNED) - 2.0 |
+---------------------------+
|                      -1.0 |
+---------------------------+
1 row in set (0.00 sec)
mysql>