Updated on 2024-12-06 GMT+08:00

Arithmetic Functions

Table 1 Arithmetic functions

MySQL

Support Unplanned ALT (Yes/No)

ABS()

Supported

ACOS()

Supported

ASIN()

Supported

ATAN()

Supported

ATAN2()

Supported

CEILING()

Supported

COS()

Supported

DEGREES()

Supported

EXP()

Supported

FLOOR()

Supported

LN()

Supported

LOG()

Supported

LOG10()

Supported

LOG2()

Supported

PI()

Supported

POW()

Supported

POWER()

Supported

RAND()

Supported

SIGN()

Supported

SIN()

Supported

SQRT()

Supported

TAN()

Supported

TRUNCATE()

Supported

CEIL()

Supported

CRC32()

Supported

CONV()

Supported