These functions' parameters are all automatically type converted to floating-point FLOATs or DOUBLEs. Unless otherwise specified, the return type is that which ensures the least loss of precision. Where the parameters are only SMALLINT or FLOAT, the return type will be FLOAT, otherwise, it will be DOUBLE. If any of the parameters are NULL, the result will also be NULL.

• ABS
• CEIL
• EXP
• FLOOR
• LOG
• LOG10
• MOD
• POW
• ROUND
• SQRT

Related

• SQL Reference
• SQL Functions and Operators