Articles

How the POINT() function works in Mariadb?

The POINT() function is a built-in function in Mariadb that returns a point geometry that represents a location in a two-dimensional space.

How the RAND() function works in Mariadb?

The RAND() function is a mathematical function in Mariadb that returns a random decimal number between 0 and 1.

How the UPPER() function works in Mariadb?

The UPPER() function in MariaDB is used to convert a string to uppercase.

How the PI() function works in Mariadb?

The PI() function is a built-in function in Mariadb that returns the value of the mathematical constant pi, which is approximately 3.14159.

How the RADIANS() function works in Mariadb?

The RADIANS() function is a mathematical function in Mariadb that returns the value of an angle in radians.

How the UPDATEXML() function works in Mariadb?

The UPDATEXML() function in MariaDB is used to modify a portion of an XML-formatted string by replacing, inserting, or deleting nodes or values within the XML structure.

How the PERIOD_DIFF() function works in Mariadb?

The PERIOD_DIFF() function is a built-in function in Mariadb that returns the number of months between two periods.

How the QUOTE() function works in Mariadb?

The QUOTE() function is a string function in Mariadb that returns a single-quoted string that is safe to use in a SQL statement.

How the UNIX_TIMESTAMP() function works in Mariadb?

The UNIX_TIMESTAMP() function in MariaDB is used to retrieve the current Unix timestamp or convert a date and time value into a Unix timestamp.

How the PERIOD_ADD() function works in Mariadb?

The PERIOD_ADD() function is a built-in function in Mariadb that returns a period that is a number of months away from a given period.