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, 266🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...