ROUNDDOWN

The ROUNDDOWN function rounds a real number to a maximum number of decimal places towards zero.

Submitted by admin on Tue, 12/04/2018 - 12:25

ROUNDUP

The ROUNDUP function rounds a real number to a maximum number of decimal places away from zero.

Submitted by admin on Tue, 12/04/2018 - 12:24

TRUNC

The TRUNC function rounds a real number to its integer part or to the real number with the specified decimal places.

Submitted by admin on Tue, 12/04/2018 - 12:22

INT

The INT function rounds a number to the nearest equal or lower integer.

Submitted by admin on Tue, 12/04/2018 - 12:21

ROUND

The ROUND function rounds a number to the nearest integer or the specified number of digits.

Submitted by admin on Tue, 12/04/2018 - 12:20

QUOTIENT

The QUOTIENT function divides two numbers and returns only the integer part of the result, discarding the rest.

Submitted by admin on Tue, 12/04/2018 - 12:19

MOD

The MOD function returns the remainder of the division of two numbers.

Submitted by admin on Tue, 12/04/2018 - 12:19

SQRT

The SQRT function returns the square root of the number passed as an argument.

Submitted by admin on Tue, 12/04/2018 - 12:17

MIN

The MIN function returns the smallest value of a column or of two scalar expressions considering numbers, dates and texts.

Submitted by admin on Tue, 12/04/2018 - 12:17