Collections:
OCT() - Calculate Octal representation
How to calculate the octal representation of a given integer using the OCT() function?
✍: FYIcenter.com
OCT(in) is a MySQL built-in function that calculates the octal representation of a given integer. For example:
SELECT OCT('255'), OCT(255); -- +------------+----------+ -- | OCT('255') | OCT(255) | -- +------------+----------+ -- | 377 | 377 | -- +------------+----------+
Reference information of the OCT() function:
OCT(in): oct 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. Arguments, return value and availability: in: Required. The input integer. oct: Return value. The octal string representation of the input. Available since MySQL 5.7.
Related MySQL functions:
⇒ OCTET_LENGTH() - Synonym for LENGTH()
⇐ MID() - Synonym for SUBSTRING()
2023-11-18, 271🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...