ID EN
String Functions and Operators

OCT(N)

MySQL 8.4

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.

Syntax

MYSQL
SELECT OCT(12);
'14'

Examples

Example
MYSQL
SELECT OCT(12);
'14'