In MySQL, the CEILING() function allows you to round a number up to the nearest integer. More specifically, it returns the smallest integer not less than its argument.
You can also use the CEIL() function, which is a synonym for CEILING().
Tag: mathematical functions
MySQL FLOOR() Function – Round Down to the Nearest Integer
In MySQL, the FLOOR() function allows you to round a number down to the nearest integer. More specifically, it returns the largest integer not larger than its argument.
2 Ways to Convert between Decimal and Hexadecimal in MySQL
This article presents two methods for converting a decimal number to its hexadecimal equivalent in MySQL.
More specifically, I present two functions that enable you to do this conversion. The two functions are as follows:
- The
HEX()function - The
CONV()function
Below is an explanation of each function.
How to “Unhex” a Number in MySQL
In MySQL, you can unhex a string using the UNHEX() function. But you can’t unhex a number with that function.
To unhex a number in MySQL, use the CONV() function instead.
The CONV() function allows you to convert numeric values between different numbering systems. For example, you can convert between say decimal and binary, octal to decimal, or, more relevant to this article, between hexadecimal and decimal.
CONV() – Convert Numbers Between Different Bases in MySQL
When working with MySQL, you can use the CONV() function to convert a number from one base to another. It takes three arguments; the number to convert, the original base, and the base you want to convert it to.
BIN() – Get the Binary Value of a Number in MySQL
In MySQL you can use the BIN() function to return a binary representation of a number. This function actually returns a string representation of the binary value.