Math

​

ABS

ABS(numeric_expression)

• numeric_expression The expression of an indeterminate numeric data type except for the bit data type.

SELECT ABS(15);
-- Result: 15

SELECT ABS(-15);
-- Result: 15

​

ACOS

ACOS(float_expression)

• float_expression The float expression that specifies the cosine of the angle to be returned. Values outside the range from -1 to 1 return null.

SELECT ACOS(0.5);
-- Result: 1.0471975511966

​

ASIN

ASIN(float_expression)

• float_expression The float expression that specifies the sine of the angle to be returned. Values outside the range from -1 to 1 return null.

SELECT ASIN(0.5);
-- Result: 0.523598775598299

​

ATAN

ATAN(float_expression)

• float_expression The float expression that specifies the tangent of the angle to be returned.

SELECT ATAN(10);
-- Result: 1.47112767430373

​

ATN2

ATN2(float_expression1, float_expression2)

• float_expression1 The float expression that is the y-coordinate.
• float_expression2 The float expression that is the x-coordinate.

SELECT ATN2(1, 1);
-- Result: 0.785398163397448

​

CEILING

CEILING ( numeric_expression ) or CEIL( numeric_expression )

• numeric_expression The expression of an indeterminate numeric data type except for the bit data type.

SELECT CEILING(1.3);
-- Result: 2

SELECT CEILING(1.5);
-- Result: 2

SELECT CEILING(1.7);
-- Result: 2

​

COS

COS(float_expression)

• float_expression The float expression of the specified angle in radians.

SELECT COS(1);
-- Result: 0.54030230586814

​

COT

COT(float_expression)

• float_expression The float expression of the angle in radians.

SELECT COT(1);
-- Result: 0.642092615934331

​

DEGREES

DEGREES(numeric_expression)

• numeric_expression The angle in radians, an expression of an indeterminate numeric data type except for the bit data type.

SELECT DEGREES(3.1415926);
-- Result: 179.999996929531

​

EXP

EXP(float_expression)

• float_expression The float expression.

SELECT EXP(2);
-- Result: 7.38905609893065

​

EXPR

EXPR(expression)

• expression The expression. Operators allowed are +, -, \*, /, ==, !=, >, <, >=, and <=.

SELECT EXPR('1 + 2 * 3');
-- Result: 7

SELECT EXPR('1 + 2 * 3 == 7');
-- Result: true

​

FLOOR

FLOOR(numeric_expression)

• numeric_expression The expression of an indeterminate numeric data type except for the bit data type.

SELECT FLOOR(1.3);
-- Result: 1

SELECT FLOOR(1.5);
-- Result: 1

SELECT FLOOR(1.7);
-- Result: 1

​

GREATEST

GREATEST(int1,int2,....)

SELECT GREATEST(3,5,8,10,1)
-- Result: 10

​

HEX

HEX(value)

• value: A string or numerical value to be converted into hex.

SELECT HEX(866849198);
-- Result: 33AB11AE

SELECT HEX('Sample Text');
-- Result: 53616D706C652054657874

​

LEAST

LEAST(int1,int2,....)

SELECT LEAST(3,5,8,10,1)
-- Result: 1

​

LOG

LOG( float_expression [, base ] )

• float_expression The float expression.
• base The optional integer argument that sets the base for the logarithm.

SELECT LOG(7.3890560);
-- Result: 1.99999998661119

​

LOG10

LOG10( float_expression )

• float_expression The expression of type float.

SELECT LOG10(10000);
-- Result: 4

​

MOD

MOD(dividend,divisor)

• dividend The number to take the modulus of.
• divisor The number to divide the dividend by when determining the modulus.

SELECT MOD(10,3);
-- Result: 1

​

NEGATE

NEGATE(real_number)

• real_number The real number to find the opposite of.

SELECT NEGATE(10);
-- Result: -10

SELECT NEGATE(-12.4)
--Result: 12.4

​

PI

PI()

SELECT PI()
-- Result: 3.14159265358979

​

POWER

POWER(float_expression , y)

• float_expression The float expression.
• y The power to raise float_expression to.

SELECT POWER(2, 10);
-- Result: 1024

SELECT POWER(2, -2);
-- Result: 0.25

​

RADIANS

RADIANS(float_expression)

• float_expression The degrees of the angle as a float expression.

SELECT RADIANS(180);
-- Result: 3.14159265358979

​

RAND

RAND( [ integer_seed ] )

• seed The optional integer expression that specifies the seed value. If seed is not specified, a seed value at random will be assigned.

SELECT RAND();
-- This result may be different, since the seed is randomized
-- Result: 0.873159630165044

SELECT RAND(1);
-- This result will always be the same, since the seed is constant
-- Result: 0.248668584157093

​

ROUND

ROUND( numeric_expression [ ,integer_length] [ ,function ] )

• numeric_expression The expression of a numeric data type.
• length The optional precision to round the numeric expression to. When this is omitted, the default behavior will be to round to the nearest whole number.
• function The optional type of operation to perform. When the function parameter is omitted or has a value of 0 (default), numeric_expression is rounded. When a value other than 0 is specified, numeric_expression is truncated.

SELECT ROUND(1.3, 0);
-- Result: 1

SELECT ROUND(1.55, 1);
-- Result: 1.6

SELECT ROUND(1.7, 0, 0);
-- Result: 2
SELECT ROUND(1.7, 0, 1);
-- Result: 1

SELECT ROUND (1.24);
-- Result: 1.0

​

SIGN

SIGN(numeric_expression)

• numeric_expression The expression of an indeterminate data type except for the bit data type.

SELECT SIGN(0);
-- Result: 0

SELECT SIGN(10);
-- Result: 1

SELECT SIGN(-10);
-- Result: -1

​

SIN

SIN(float_expression)

• float_expression The float expression specifying the angle in radians.

SELECT SIN(1);
-- Result: 0.841470984807897

​

SQRT

SQRT(float_expression)

• float_expression The expression of type float.

SELECT SQRT(100);
-- Result: 10

​

SQUARE

SQUARE(float_expression)

• float_expression The expression of type float.

SELECT SQUARE(10);
-- Result: 100

SELECT SQUARE(-10);
-- Result: 100

​

TAN

TAN(float_expression)

• float_expression The expression of type float.

SELECT TAN(1);
-- Result: 1.5574077246549

​

TRUNC

TRUNC(decimal_number,precision)

• decimal_number The decimal value to truncate.
• precision The number of decimal places to truncate the decimal number to.

SELECT TRUNC(10.3423,2);
-- Result: 10.34