In SQL Server, we can use the ISNUMERIC() function to return numeric values from a column.
We can alternatively run a separate query to return all values that contain numeric data.
Continue readingTag: numeric functions
Find Non-Numeric Values in a Column in SQL Server
There may be occasions where you need to check a column for non-numeric values. For example, you discover that a column is a varchar column when it really should be a numeric column.
This is easily done in SQL Server with the ISNUMERIC() function.
FORMAT() Examples in MySQL
In MySQL, the FORMAT() function returns a number formatted to a specified number of decimal places.
It includes group separators and a decimal separator where applicable.
Continue readingMariaDB FLOOR() vs TRUNCATE()
MariaDB has a FLOOR() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
Below is a quick rundown on the difference between FLOOR() and TRUNCATE() in MariaDB.
MariaDB ROUND() vs TRUNCATE()
MariaDB has a ROUND() function and a TRUNCATE() function that can return the same results or different results, depending on the exact value of their arguments.
As the function names suggest, ROUND() rounds the number and TRUNCATE() truncates the number. Truncating a number simply cuts it off without performing any rounding.
Below is a quick rundown on the difference between ROUND() and TRUNCATE() in MariaDB.
MariaDB ROUND() vs FLOOR()
MariaDB has a ROUND() function and a FLOOR() function that are similar in some ways, but quite different in other ways.
Below is a quick rundown on the difference between ROUND() and FLOOR() in MariaDB.
TO_CHAR(number) Function in Oracle
In Oracle Database, the TO_CHAR(number) function converts a number to a VARCHAR2 value in the format specified by the format argument.
Numeric Functions in Oracle (Full List)
Below is a list of numeric functions in Oracle Database.
Continue readingMariaDB Numeric Functions (Full List)
This article contains a full list of built-in MariaDB numeric functions and operators.
Continue readingWIDTH_BUCKET() Function in Oracle
In Oracle, the WIDTH_BUCKET() function allows you to construct equiwidth histograms, in which the histogram range is divided into intervals that have identical size.
For a given expression, WIDTH_BUCKET() returns the bucket number into which the value of this expression would fall after being evaluated.