OCT

Convert to octal. This function returns the octal string representation of a numeric argument.

Syntax

OCT(N)

Description

Returns a string representation of the octal value of N, where N is a longlong (BIGINT) number. This is equivalent to CONV(N,10,8). Returns NULL if N is NULL.

Examples

SELECT OCT(34);
+---------+
| OCT(34) |
+---------+
| 42      |
+---------+

SELECT OCT(12);
+---------+
| OCT(12) |
+---------+
| 14      |
+---------+

See Also

• CONV()

• BIN()

• HEX()

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}