Database Management Systems
In SQL Server, the T-SQL FLOOR() function allows you to round a number down to the nearest integer. More specifically, it returns the largest integer less than or equal to the specified numeric expression.
You provide the number as an argument. The return data type is the same as the one provided as an argument.
In SQL Server, the T-SQL CEILING() function allows you to round a number up to the nearest integer. More specifically, it returns the smallest integer greater than, or equal to, the specified numeric expression.
You provide the number as an argument. The return data type is the same as the one provided as an argument.
In SQL Server, the ATN2() function returns the arctangent between two values. Specifically, it returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions.
You provide the values as arguments when calling the function.
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.
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.
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.
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).
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.
In MySQL, the TAN() function returns the tangent of a value.
You provide the value as an argument when calling the function.
In MySQL, the SQRT() function returns the square root of a nonnegative number.
You provide the number as an argument when calling the function.