In SQLite, the SQRT() function calculates the square root of a number. It returns the value which, when multiplied by itself, equals the input number.
Note that SQLite returns NULL if you try to calculate the square root of a negative number, NULL, or a value of the wrong type.
The ASINH() function in SQLite calculates the inverse hyperbolic sine of a given numeric value. The result is the value whose hyperbolic sine is the specified number.
The PI() function in SQLite returns the mathematical constant π (pi), which is approximately 3.14159265358979. It is used to represent the ratio of the circumference of a circle to its diameter.
The PI() function is commonly employed in mathematical computations, particularly in geometry, trigonometry, and other scientific calculations involving circles and angles.
The COS() function in SQLite calculates the cosine of a given angle. The angle must be specified in radians. The result is the cosine of the angle, which is a real number between -1 and 1.
The MOD() function in SQLite is used to calculate the remainder when one number is divided by another. This operation is commonly known as the modulo operation.
The SINH() function in SQLite calculates the hyperbolic sine of a value. The hyperbolic sine is a mathematical function that can return any real number and grows exponentially as its input increases or decreases.
The log10() function in SQLite is used to calculate the base-10 logarithm of a number. This function is part of SQLite’s built-in mathematical functions, and it returns the logarithmic value of the argument passed to it.
The ATAN2() function in SQLite calculates the arc tangent (inverse tangent) of the ratio of two given numeric values, typically representing the y-coordinate and x-coordinate of a point.
Unlike ATAN(), which calculates the angle based only on a single tangent value, ATAN2() considers both the x and y values to determine the correct quadrant for the resulting angle.
The ATAN() function in SQLite calculates the arc tangent (inverse tangent) of a given numeric value. The result is the angle in radians whose tangent is the specified number.
SQLite provides various mathematical functions out of the box, and one of them is the power() function (also available as pow()).
The power() function calculates the result of raising one number to the power of another. In other words, it performs an exponentiation operation. This function is particularly useful for mathematical operations where powers or exponents are required.