Conversion
MySQL
OCT
MySQLMengkonversi angka desimal ke representasi octal string. Shorthand untuk CONV(num, 10, 8).
Tipe hasil:
VARCHARDiperbarui: 7 Jan 2026Syntax
SQL
OCT(num)Parameter
numBIGINTwajib
Angka desimal yang akan dikonversi
Contoh Penggunaan
Convert to Octal
SQL
1 SELECT OCT(8) AS octal_str;
8 desimal = 10 octal.
Hasil
octal_str: 10
File Permission
SQL
1 SELECT OCT(511) AS permission;
511 desimal = 777 octal (rwxrwxrwx).
Hasil
permission: 777
Convert Values
SQL
1 SELECT value, OCT(value) AS octal_val 2 FROM permissions;
Display nilai dalam octal.
Hasil
(values in octal)