Database Management Systems
In Oracle, the ROUND(number) function returns a number rounded to a given number of decimal places.
By default, it rounds the number to zero decimal places, but you can provide an optional argument that specifies the number of decimal places to use.
Oracle also has a ROUND(date) syntax, which is used on dates. This article is solely about the ROUND(number) syntax, which is used on numbers.
In Oracle, the CEIL() function returns the smallest integer that is greater than or equal to its argument.
In Oracle, the FLOOR() function returns the largest integer equal to or less than its argument.
In Oracle, the LOG() function returns the logarithm, base n2, of n1, where n2 is the first argument and n1 is the second.
In Oracle, the LN() function returns the natural logarithm of its argument, where the argument is greater than 0.
In other words, it returns the base-e logarithm of its argument.
The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.
In Oracle, the ATAN2() function returns the arctangent (inverse tangent) of its two arguments.
In Oracle, the ATAN() function returns the arctangent (inverse tangent) of its argument.
In other words, it returns the value whose tangent is the argument.
MariaDB has quite a number of functions that return the day from a date. It all depends on how you want to do it, and what you mean by “day”.
MariaDB needs to know whether you want the day name, the day of the week number, the day of the month, day of year, etc.
Below are 8 functions that enable you to return the day from a date in MariaDB, in its various forms.
In Oracle, the BITAND() function returns a bitwise AND of its two arguments.