MySQL in a Nutshell, 2nd Edition

Name

OCT()

Synopsis

OCT(number)

This function returns the octal, or base 8, numeric system value of the given number. It returns NULL if the argument is NULL. Here is an example:

SELECT OCT(1), OCT(9), OCT(16);

+--------+--------+---------+
| OCT(8) | OCT(9) | OCT(16) |
+--------+--------+---------+
| 10     | 11     | 20      |
+--------+--------+---------+