Mathematical Functions
| Previous | Home | Next |
Mathematical function perform numerical operation on mathematical data. The various mathematical functions are:
| Function Name | Parameter | Description |
| ABS | (numeric_expression) | Return an absolute value) |
| ACOS,ASIN, ATN | (float_expression) | Returns the angle in radians whose cosin,sin and tangent is a floating point value |
| COS,SIN,COT,TAN | (float_expression) | Returns the angle in radians whose cosin, sin, tangent and cot of the angle |
| DEGREES | (numeric_expression) | Returns the smallest integer greater than or equal to the specified value |
| EXP | (float_expression) | Return the exponential value of the specified value |
| FLOOR | (numeric_expression) | Return the largest integer less than or equal to the specified value. |
| LOG | (float_expression) | Return the natural logarithm of the specified value |
| LOG | (float_expression) | Return the natural logarithm of the specified value |
| LOG10 | (float_expression) | Return the base-10 logarithm of the specified value |
| PI | () | Returns the constant value of 3.141592653589793 |
| POWER< | (numeric_expression, y) | Return the value of numeric_expression to the value of y |
| RADIANS< | (numeric_expression) | Convert from degrees to radians |
| RAND | ([seed]) | Return a random float number between 0 and 1 |
| ROUND | (numeric_expression, length) | returns a numeric expression rounded off to the length specified as an integer expression |
| SIGN | (numeric_expression) | Returns positive, negative or zero |
| SQRT | (float_expression) | Return the square root of the specified value |
ROUND (numeric_expression,length)
numeric_expression is the numeric expression to be round off
SELECT 'value'= ROUND (123.452352,3)
Out Put:
| Previous | Home | Next |