Name

Example

ABS

SELECT ABS(-1.0), ABS(0.0), ABS(1.0)

ACOS

SELECT ACOS(0.0), ACOS(-1), ACOS(1.01)

ASIN

SELECT ASIN(-1.01), ASIN(-1.0), ASIN(0.1472738)

ATAN

SELECT ATAN(0), ATAN(-45.01), ATAN(-181.01)

CEILING

SELECT CEILING(123.45), CEILING(-123.45), CEILING(0.0)

COS

SELECT COS(-1.01), COS(-1.0), COS(14.78)

EXP

SELECT EXP(378.615345498)

FLOOR

SELECT FLOOR(123.45), FLOOR(-123.45)

LOG

SELECT LOG(5.175643)

LOG10

SELECT LOG10(145.175643)

POWER

SELECT POWER(2.0, -10000.0), POWER(10,10), POWER(100,100)

ROUND

SELECT ROUND(123.9994), ROUND(123.9995, 2)

SIGN

SELECT SIGN(123.45), SIGN(-123.45)

SIN

SELECT SIN(-1.01), SIN(-1.0), SIN(14.78)

SQRT

SELECT SQRT(1), SQRT(2), SQRT(3), SQRT(4), SQRT(-1)

TAN

SELECT TAN(3.1415926535897931)