MySQL OCT Function

MySQL OCT is one of the String Function which converts the given value to Octal number. The OCT function returns the string representation of that Octal number.

MySQL OCT Syntax

The basic syntax of the OCT Function in MySQL is as shown below:

SELECT OCT(N)

MySQL Octal Function Example

The Octal Function in MySQL converts the user specified number to Octal Number. Next, it returns the Output in String format. The following query shows you multiple ways to use this OCT function.

SELECT OCT(10);

SELECT OCT(225);

SELECT OCT(33456);

OUTPUT