In SQL Server, the ATAN() function returns the arctangent of a value. In other words, it returns the angle, in radians, whose tangent is a specified float expression.
You provide the value as an argument when calling the function.
Tag: mathematical functions
ASIN() Examples in SQL Server
Using SQL Server, you can use the T-SQL ASIN() function to return the arcsine of a number. In other words, this function returns the angle, in radians, whose sine is the specified float expression.
The return data type is float.
You provide the number as an argument when calling the function.
ACOS() Examples in SQL Server
Using SQL Server, you can use the T-SQL ACOS() function to return the arccosine of a number. In other words, this function returns the angle, in radians, whose cosine is the specified float expression.
The return data type is float.
You provide the number as an argument when calling the function.
ABS() Examples in SQL Server
In SQL Server, the ABS() function returns the absolute value of a specified value.
You provide the value as an argument. The return value is of the same type as the argument.
An absolute value is the distance of a number on the number line from 0 without considering which direction from zero the number lies. Therefore, the absolute value of a number is always a non-negative value (i.e. it’s never negative).
MySQL TRUNCATE() Function – Truncate a Number to a Specified Number of Decimal Places
In MySQL, the TRUNCATE() function truncates a value to a specified number of decimal places.
The function accepts two arguments; the value, and the number of decimal places to truncate that value to.
All numbers are rounded toward zero.
MySQL TAN() Function – Return the Tangent of a Value in MySQL
In MySQL, the TAN() function returns the tangent of a value.
You provide the value as an argument when calling the function.
MySQL SQRT() Function – Return the Square Root of a Number in MySQL
In MySQL, the SQRT() function returns the square root of a nonnegative number.
You provide the number as an argument when calling the function.
MySQL SIN() Function – Return the Sine of a Number in MySQL
In MySQL, the SIN() function returns the sine of a given value, where the value is given in radians.
The sine is a trigonometric function of an angle. The sine of an acute angle is defined in the context of a right triangle: for the specified angle, it is the ratio of the length of the side that is opposite that angle to the length of the longest side of the triangle (the hypotenuse).
MySQL SIGN() Function – Find Out Whether a Number is Positive or Negative in MySQL
In MySQL, the SIGN() function returns the sign of a number. That is, it indicates whether or not the value is a positive number, a negative number, or zero.
You provide the value as an argument when calling the function.
The function returns the following result, depending on whether the argument is positive, negative, or zero.
- 1 if the number is positive
- -1 if the number is negative
- 0 if the number is zero
MySQL POW() Function – Raise a Value to the Power of Another Value
In MySQL, the POW() function raises a number to the power of another number.
You provide the two values as arguments when calling the function.