• ⌂ Math
• Functions
  • ABS()
  • CEIL()
  • CEILING()
  • FLOOR()
  • FORMAT()
  • HEX()
  • OCT()
  • RAND()
  • ROUND()
  • UNHEX()

OCT()

Returns a string representation of the octal value of N, where N is a BIGINT number.  Returns NULL if N is NULL.

Prototype

mixed OCT(int num)

Parameter

• num - Number to convert to its octal value.

Return

Returns a string representation of the octal value of N, where N is a BIGINT number.  Returns NULL if N is NULL.

Example

SELECT OCT(OID) AS OctOID, Name FROM Contact

Related

ORD() in MySQL Docs

• < HEX()
• RAND() >