Numeric Functions

1min

Numeric functions in Oxla are designed to perform mathematical calculations and manipulate integer or floating-point numbers. Oxla supports the following numeric functions:
Functions
Description
﻿CEIL()﻿
This function rounds up to the nearest positive or negative integer value greater than or equal to the argument.
﻿ABS()﻿
This function returns the absolute value of an argument, regardless of whether it is positive or negative.
﻿SQRT()﻿
This function returns the square root of its argument.
﻿RANDOM()﻿
This function returns a random number between 0 (inclusive) and 1 (exclusive).
﻿FLOOR()﻿
This function returns a number rounded down that is less than or equal to the specified argument. 
﻿LN()﻿
This function returns the exponential value of its argument.
﻿SIN()﻿
This function returns the trigonometric sine value of a specified angle in radians.
﻿

Updated 11 May 2023

Did this page help you?

Yes

SQL Functions

CEIL

Docs powered by archbee

Functions	Description
CEIL()	This function rounds up to the nearest positive or negative integer value greater than or equal to the argument.
ABS()	This function returns the absolute value of an argument, regardless of whether it is positive or negative.
SQRT()	This function returns the square root of its argument.
RANDOM()	This function returns a random number between 0 (inclusive) and 1 (exclusive).
FLOOR()	This function returns a number rounded down that is less than or equal to the specified argument.
LN()	This function returns the exponential value of its argument.
SIN()	This function returns the trigonometric sine value of a specified angle in radians.