D/MySQL

[MySQL] OCT()

yeon.Biju 2020. 4. 14. 14:46

MySQL 문자열 함수와 연산자

 

OCT()

   -

 

OCT(N)

의 형태

 

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.

 

mysql> SELECT OCT(12);
+---------+
| OCT(12) |
+---------+
| 14      |
+---------+
1 row in set (0.00 sec)