MySQL OCT Function

MySQL OCT is one of the String Function which is used to convert the given value to Octal number, and returns the string representation of that Octal number.

In this article, we will show you, How to use this string OCT in MySQL with example.

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

Thank You for Visiting Our Blog