「MariaDB」10進数の整数を8進数に変換する
環境
Windows 10 64 bit
MariaDB 10.6.4
書式
OCT( 数値 )
OCT関数を使用することで数値を10進数から8進数へ変換します
1.10進数を8進数へ変換します
MariaDB [(none)]> SELECT OCT( 121 );
+------------+
| OCT( 121 ) |
+------------+
| 171 |
+------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT OCT( 121 );
+------------+
| OCT( 121 ) |
+------------+
| 171 |
+------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT OCT( 121 ); +------------+ | OCT( 121 ) | +------------+ | 171 | +------------+ 1 row in set (0.000 sec)
2.8進数を10進数に変換します
書式
CONV( 8進数, 8, 10 );
操作例
MariaDB [(none)]> SELECT CONV( 171,8,10 );
+------------------+
| CONV( 171,8,10 ) |
+------------------+
| 121 |
+------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT CONV( 171,8,10 );
+------------------+
| CONV( 171,8,10 ) |
+------------------+
| 121 |
+------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT CONV( 171,8,10 ); +------------------+ | CONV( 171,8,10 ) | +------------------+ | 121 | +------------------+ 1 row in set (0.000 sec)