|
TurboSQL Guide Arithmetic Functions and Operators |
| Previous Top Next |
This is a list of arithmetic functions and operators that can be used in TurboSQL.
+
Syntax
value1 + value2
Description
Calculates the sum of two numbers.
-
Syntax
value1 - value2
Description
Calculates the difference of two numbers.
*
Syntax
value1 * value2
Description
Calculates the product of two numbers.
/
Syntax
value1 / value2
Description
Calculates the quotient of two numbers.
%
Syntax
value1 % value2
Description
Calculates the modulo of two integral numbers.
Compatibility Information
This operator is only available in TurboDB Managed.
ARCTAN
Syntax
ARCTAN(value)
Description
Calculates the arcus tangens of value.
CEILING
Syntax
CEILING(value)
Description
Calculates the smallest integral number greater than, or equal to, the given value.
Example
CEILING(-3.8) --returns -3.0
CEILING(3.8) --returns 4.0
COS
Syntax
COS(value)
Description
Calculates the cosine of value.
DIV
Syntax
a div b
Description
Integer division
Example
35 div 6 --returns 5
-35 div 6 --returns -5
35 div -6 --returns -5
-35 div -6 --returns 5
EXP
Syntax
EXP(:X DOUBLE) RETURNS DOUBLE
Description
Calculates the exponential of value (to base e)
FLOOR
Syntax
FLOOR(:X DOUBLE) RETURNS DOUBLE
Description
Calculates the largest integral number less than or equal to the given value.
Example
FLOOR(-3.8) --returns -4.0
FLOOR(3.8) --returns 3.0
FRAC
Syntax
FRAC(:X DOUBLE) RETURNS DOUBLE
Description
Calculates the fractional part of real number.
Example
FRAC(-3.8) --returns -0.8
FRAC(3.8) --returns 0.8
INT
Syntax
INT(:X DOUBLE) RETURNS BIGINT
Description
Calculates the integral part of a real number as an integer number.
Example
INT(-3.8) --returns -3
INT(3.8) --returns 3
LOG
Syntax
LOG(:X DOUBLE) RETURNS BIGINT
Description
Calculates the natural logarithm of a real number.
MOD
Syntax
a mod b
Description
Remainder of the integer division. a mod b = a - (a div b) * b always holds.
Example
35 mod 6 --returns 5
35 mod -6 --returns 5
-35 mod 6 --returns 5
-35 mod -6 --returns 5
ROUND
Syntax
ROUND(:X DOUBLE [, :Precision BYTE]) RETURNS DOUBLE
Description
Rounds the value to the given number of digits.
Compatibility Information
This function is only available in TurboDB Win.
Example
ROUND(3.141592, 3) --returns 3.142
SIN
Syntax
SIN(:X DOUBLE) RETURNS DOUBLE
Description
Calculates the sine of a value.
SQRT
Syntax
SQRT(:X DOUBLE) RETURNS DOUBLE
Description
Calculates the square root of a value.
See also
General Functions and Operators
Arithmetic Functions and Operators
String Functions and Operators
Date and Time Functions and Operators
Aggregation Functions
Miscellaneous Functions and Operators