UnityJDBC - Mathematical Functions

Summary

Function Syntax Description
ABS ABS(expr) Returns the absolute value of expr.
ACOS ACOS(expr) Returns the arc cosine of expr.
ASIN ASIN(expr) Returns the arc sine of expr.
ATAN ATAN(expr) Returns the arc tangent of expr.
ATAN2 ATAN2( expr1, expr2) Returns the arc tangent of expr2 / expr1.
CEILING CEILING( expr) Computes the ceiling of expr.
COS COS(expr) Returns the cosine of expr.
COT COT(expr) Returns the cotangent of expr.
DEGREES DEGREES(expr) Converts from radians to degrees.
EXP EXP(expr) Computes the exponential of expr.
FLOOR FLOOR(expr) Computes the floor of expr.
INC INC() Produces an integer sequence starting at 1.
LN LN(expr) Computes natural logarithm.
LOG LOG(expr) Computes natural logarithm of expr.
LOG10 LOG10(expr) Returns the base-10 logarithm of expr.
MOD expr1 % expr2 Returns the remainder of expr1 divided by expr2.
PI PI() Returns the value of pi.
POWER POWER(expr1, expr2) Computes expr1 to the expr2-th power.
RADIANS RADIANS(expr) Returns expr converted from degrees to radians.
RAND RAND() Generates a random number between 0 and 1.
RAND RAND(expr) Generates a random number between 0 and 1 given a seed.
RANDOM RANDOM(expr) Generates a random number between 0 and 1 given a seed.
RANDOM RANDOM() Generates a random number between 0 and 1.
ROUND ROUND(expr1, expr2) Rounds expr1 to expr2 decimal places.
ROUND ROUND(expr) Rounds expr to an integer value.
SIGN SIGN(expr) Returns sign of the argument (-1, 0, +1).
SIN SIN(expr) Returns the sine of expr given in radians.
SQRT SQRT(expr) Computes the square root of expr.
TAN TAN(expr) Returns the tangent of expr given in radians.

Detailed Function Descriptions

ABS

Syntax: ABS(expr)

Returns the absolute value of expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

ACOS

Syntax: ACOS(expr)

Returns the arc cosine of expr, that is, the value whose cosine is expr. Returns NULL if expr is not in the range -1 to 1.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

ASIN

Syntax: ASIN(expr)

Returns the arc sine of expr, that is, the value whose sine is expr. Returns NULL if expr is not in the range -1 to 1.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

ATAN

Syntax: ATAN(expr)

Returns the arc tangent of expr, that is, the value whose tangent is expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

ATAN2

Syntax: ATAN2( expr1, expr2)

Returns the arc tangent of the two variables expr1and expr2. It is similar to calculating the arc tangent of expr2 / expr1, except that the signs of both arguments are used to determine the quadrant of the result.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

CEILING

Syntax: CEILING( expr)

Computes the ceiling of a numeric value expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

COS

Syntax: COS(expr)

Returns the cosine of expr given in radians.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

COT

Syntax: COT(expr)

Returns the cotangent of expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

DEGREES

Syntax: DEGREES(expr)

Returns the argument expr converted from radians to degrees.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

EXP

Syntax: EXP(expr)

Computes the exponential of expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

FLOOR

Syntax: FLOOR(expr)

Computes the floor of expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

INC

Syntax: INC()

This function produces an integer sequence starting at 1. e.g. 1,2,3,4,.. A new number is assigned for each tuple processed.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

LN

Syntax: LN(expr)

Computes natural logarithm of expr. Equivalent to LOG() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

LOG

Syntax: LOG(expr)

Computes natural logarithm of expr. Equivalent to LN() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

LOG10

Syntax: LOG10(expr)

Returns the base-10 logarithm of expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

MOD

Syntax: expr1 % expr2

Returns the remainder of expr1 divided by expr2.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

PI

Syntax: PI()

Returns the value of pi.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

POWER

Syntax: POWER(expr1, expr2)

Computes expr1 to the expr2-th power.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

RADIANS

Syntax: RADIANS(expr)

Returns expr converted from degrees to radians.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

RAND

Syntax: RAND()

Generates a random number between 0 and 1. Equivalent to RANDOM() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

RAND

Syntax: RAND(expr)

Generates a random number between 0 and 1. The parameter is the seed.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

RANDOM

Syntax: RANDOM(expr)

Generates a random number between 0 and 1. The parameter is the seed.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

RANDOM

Syntax: RANDOM()

Generates a random number between 0 and 1. Equivalent to RAND() function.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

ROUND

Syntax: ROUND(expr1, expr2)

Rounds expr1 to expr2 decimal places.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

ROUND

Syntax: ROUND(expr)

Rounds expr to an integer value.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

SIGN

Syntax: SIGN(expr)

Returns -1 if expr is smaller than 0, 0 if expr==0 and 1 if expr is bigger than 0.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

SIN

Syntax: SIN(expr)

Returns the sine of expr given in radians.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

SQRT

Syntax: SQRT(expr)

Computes the square root of expr.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB

TAN

Syntax: TAN(expr)

Returns the tangent of expr given in radians.

SQL Server Access Oracle PostgreSQL MySQL Sybase HSQLDB